Re: Temp tables on Oracle

Bob,

There is no #temp type table in Oracle, however you can create a table easily in a sql script, do your processing and then drop it, or even better, create the table, and then issue a truncate command on it after your processing has finished. You can also build a table in a pl/sql program, using the new dbms_sql package.

Hope this helps,

Vikram Goel

Motorola - Byonton Beach, FL

Private email vgoel_at_emi.net

Bob Beauchemin <bobb_at_udp.com> wrote:
> 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 Fri Nov 03 1995 - 00:00:00 CET