Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-chat by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group