Help: Temporary tables

From: <johnb_at_anvil.co.uk>
Date: Tue, 06 Oct 1998 10:44:43 GMT
Message-ID: <6vcsar$5i4$1@nnrp1.dejanews.com>

In sybase you can create a temporary table within a stored procedure and then use the temporary table in a query like any other table. Does oracle have the same feature ? if not how is this achieved.

E.g
In sybase:
create procedure foo
as begin

/* Create a temporary table "#tmp_table" - the hash ('#') prefix in sybase is used to create a temporary table */

select * into #tmp_table from real_table_A

select * from #tmp_table, real_table_B
where #tmp_table.column = real_table_B.column

end

Thanks in advance
John

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 06 1998 - 05:44:43 CDT