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

Hi

Look into DBMS_SQL

cheers

pete Finnigan
www.pentest-limited.com

In article <ii1q7.4809$JN.18991_at_news1.sttls1.wa.home.com>, Jim Kennedy <kennedy-family_at_home.com> writes
>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
>
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com