In Oracle, you can specify in which TABLESPACE you want to create table so you can create the table in the temporary TABLESPACE.

The other ways to do it is to use CREATE VIEW AS SELECT or PL-SQL CURSOR.


>All,
>
>I have stored procedure in SQL Server that I need to emulate in Oracle. The procedure creates a temporary table with an identity field, loads data into the temp table, then selects a subset to return to a web form.
>
>In SQL Server you create a temp table using:
>
>CREATE TABLE #TempTable
> OrderId int IDENTITY,
> OtherFields varchar(50))
>
>I am looking for a similar object in Oracle.
>
>TIA
>
>Rex