Re: Temporary tables

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Mon, 26 Apr 1999 19:45:32 +0100
Message-ID: <7g28qc$9kc$1@news.inet.tele.dk>

<pcmerc_at_my-dejanews.com> wrote in message news:7fvqfp$lnn$1_at_nnrp1.dejanews.com...
> Hi
> Can anyone please tell me how to create temporary table in Oracle.
> I know in sybase it can be done by saying
> select column_name from table_name into #temp_table_name.
>
> Thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Temporary tables are a new feature of Oracle 8.1:

create global temporary table temp (
x number,
y varchar2(10)
);

Data in this table will exist for the duration of the user session that created them only. There's another type of temporary table where the data will exist for the duration of the transaction that created them only.

HTH. Finn Received on Mon Apr 26 1999 - 13:45:32 CDT