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

From: Greg Teets <gteets_at_cinci.rr.com>
Date: Fri, 21 Sep 2001 14:47:29 GMT
Message-ID: <3bab5089.319749750@news-server.cinci.rr.com>

Please explain this in more detail. I'm not sure what you mean here.

> Instead use global temporary tables. (Actually, most sqlserver
>people do that and 95% of the time there is no need to in Oracle.)

Thanks.

On Wed, 19 Sep 2001 13:43:42 GMT, "Jim Kennedy" <kennedy-family_at_home.com> wrote:

>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 Fri Sep 21 2001 - 09:47:29 CDT