Re: 'temp' oracle tables

In article <5im19u$dnh_at_cronkite.ocis.temple.edu>, gopal_at_astro.temple.edu says...
>
> Hi Guys,
>
> We are in the middle of porting a rather complex
> SQL Server app. to Oracle 7.3.x.
>
> I confess at the outset that I am new to Oracle.
>
> I would like to find out about how to create and user 'temp' tables
> in Oracle in a manner similar to SQL Server. In SQL Server
> it is possible to create temp tables in a stored procedure and this
> table is only visible to that procedure and dies after the
> procedure completes.
>
> Thank You
>
> Regards
>
> Gopal
> please email to gopal_at_astro.ocis.temple.edu
>

You can use the dbms_sql package to create "temp" tables. However, after you create one and use it, you must explicitely drop it. You also need to understand how this works when your code is in a stored procedure vs. a standalone procedure. If the owner of the stored procedure has the create any table priviledge, the procedure can create the table in other userid's space by concatenating the name of the user running the package to the name of the temp table. That user then doesn't need create table procedure.

-- 
Frances Edelstein
Author of "Learning Oracle Database Programming"
Relational Business Systems
fran_at_rbsbooks.com
http://www.rbsbooks.com