Temp tables on Oracle
From: Bob Beauchemin <bobb_at_udp.com>
Date: 1995/11/02
Message-ID: <47anpo$7v0_at_news.jf.intel.com>#1/1
Date: 1995/11/02
Message-ID: <47anpo$7v0_at_news.jf.intel.com>#1/1
Another beginner question...
Is there a concept of temporary tables, unique by
user/process id on Oracle? Is so, how does one specify them?
I'm looking to use a temporary table to store the results
of a query for further processing. I was told I could define
a "permenent" table and insert/delete records that were
uniquified by a sequence. But this would cause I huge amount
of activity and fragmentation on the single table.
A better solution would be the equivalent of the #temp
table type. Does Oracle support this?
Bob Beauchemin
bobb_at_udp.com
Received on Thu Nov 02 1995 - 00:00:00 CET