Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can i make stored procedure for creating several tables?
If you are using 8i then the execute immediate will work. However, if you
are doing this to create some sort of table for a temporary result that you
will then drop don't do it. Performance of your database will be very
adversely affected. Instead use global temporary tables. (Actually, most
sqlserver people do that and 95% of the time there is no need to in Oracle.)
Jim
"Leader" <sohelcsc_at_yahoo.com> wrote in message
news:b1a93c73.0109190330.6fcb7da0_at_posting.google.com...
> Hi everybody.
> can anyone show me an example of creating table through procedure.
>
> sohel
Received on Wed Sep 19 2001 - 08:43:42 CDT