Re: Can i create stored procedure to create tables and sequences?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 16 Sep 2001 12:11:58 +0200
Message-ID: <tq8unqk0ic7h96@news.demon.nl>

"Leader" <sohelcsc_at_yahoo.com> wrote in message news:b1a93c73.0109160044.53636412_at_posting.google.com...
> hi everybody,
> i want to know, whether i can create stored procedure in oracle to
> create tables and sequences in oracle database. if i can then anyone
> can please give me and example of creating stored procedure like that.
> i will be grateful to you.
>
> thanks
> sohel

Check out the Oracle supplied dbms_sql package for Oracle 7.3 and 8.0 and the execute immediate command in Oracle 8i in your documentation.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sun Sep 16 2001 - 05:11:58 CDT