Temporary tables

From: <jblankson_at_my-dejanews.com>
Date: Tue, 06 Oct 1998 10:20:05 GMT
Message-ID: <6vcqsk$42h$1@nnrp1.dejanews.com>

In sybase I can create temporary tables in a stored procedure to store intermediate results and I can use that temp table in a query as any other table. Does oracle provide you with a similar kind of thing ?

e.g

in sybase:

create procedure foo
begin

/* creates my temporary table "#tmp" */ select * into #tmp from real_table

select * from #tmp, real_table_b
where #tmp.column = real_table_b.column

end

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Oct 06 1998 - 05:20:05 CDT