Help for converting Oracle Script
От
Sawant, Nandu
Тема
Help for converting Oracle Script
Дата
Msg-id
2E314DE03538984BA5634F12115B3A4E5C1646@email1.mitretek.org
Список
Дерево обсуждения
Help for converting Oracle Script "Sawant, Nandu" <nandakumar.sawant@mitretek.org>
Re: Help for converting Oracle Script Robert Treat <xzilla@users.sourceforge.net>
Hello,
I have following Oracle script and trying to convert it for Postgres syntax:
= = = = = = = = = = = = = = =
prompt Enter value for monyy (Month Year; Ex-mar02 indicating March 2002)
define MONYY = &monyy
spool create_new_lerg_&MONYY._accounts.lst
prompt create user acc_&MONYY.
create user acc_&MONYY.
identified by lerg
temporary tablespace temp
default tablespace prices
quota unlimited on prices;
grant normal to acc_&MONYY.;
= = = = = = = = = = = = = = =
If I enter mar02 as a input for the defined variable MONYY, then it creates the ACC_MAR02 user in the database. Is there any equivalent for “define” statement in Postgres? Your help is appreciated.
Thanks,
Nandu.
В списке pgsql-chat по дате отправления