pg.ddx.io  pgsql-chat@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Help for converting Oracle Script
2+ messages / 2 participants
[nested] [flat]

* Help for converting Oracle Script
@ 2005-10-24 19:33  Sawant, Nandu <nandakumar.sawant@mitretek.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Sawant, Nandu @ 2005-10-24 19:33 UTC (permalink / raw)
  To: 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.

 

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Help for converting Oracle Script
@ 2005-10-24 23:47  Robert Treat <xzilla@users.sourceforge.net>
  parent: Sawant, Nandu <nandakumar.sawant@mitretek.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Robert Treat @ 2005-10-24 23:47 UTC (permalink / raw)
  To: pgsql-chat; +Cc: Sawant, Nandu <nandakumar.sawant@mitretek.org>

On Monday 24 October 2005 15:33, Sawant, Nandu wrote:
> 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.

I don't think there is a natural equivilant for that in PostgreSQL. More to 
the point though, this mailing list is no longer active, so if you want real 
help, try posting to pgsql-general. 

-- 
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-10-24 23:47 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-10-24 19:33 Help for converting Oracle Script Sawant, Nandu <nandakumar.sawant@mitretek.org>
2005-10-24 23:47 ` Robert Treat <xzilla@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox