Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can i make stored procedure for creating several tables?

Re: Can i make stored procedure for creating several tables?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Wed, 19 Sep 2001 13:43:42 GMT
Message-ID: <ii1q7.4809$JN.18991@news1.sttls1.wa.home.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US