Re: temporary table

Hi,

        There are not one , but in many ways Oracle can do this. You can try out the DBMS package execute_ddl. This can be called directly from your package/procedure with the ddl you want to execute.

Else I am using another way. you can use the dbms_sql package to write two lines of dynamic sql and execute the dbms_sql.parse() which will execute any DDL in the SQL world.

Hope this helps
sanjay.

kelvinw_at_asymetrix.com wrote:
>>I hope this question doesn't offence anyone in this user group. I
>have a bunch of stored procedures written in MSSQL. In the MSSQL, it
>allows to create a temporary table within a stored procedure. I have
>looked up couple oracle books but I couldn't find something similar to
>it. Does Oracle has that feature? Can someone point me the directory?
>Is there any equivalent to it or any alternatives?
>
>Any help is appreciated.
>
>
Received on Sat May 29 1999 - 15:28:49 CDT