Help for converting Oracle Script

From: "Sawant, Nandu" <nandakumar(dot)sawant(at)mitretek(dot)org>
To: <pgsql-chat(at)postgresql(dot)org>
Subject: Help for converting Oracle Script
Date: 2005-10-24 19:33:12
Message-ID: 2E314DE03538984BA5634F12115B3A4E5C1646@email1.mitretek.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-chat

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.

Responses

Browse pgsql-chat by date

  From Date Subject
Next Message Robert Treat 2005-10-24 23:47:07 Re: Help for converting Oracle Script
Previous Message Robert Treat 2005-04-09 02:21:24 Re: Pregunta de migracin