Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can i create stored procedure to create tables and sequences?
"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