Re: Tmp tables in oracle?!@#!

You need Oracle 8.1.5 to create 'global temporary' tables associated with the schema. These table definitions exist permanently, and can be used pretty much like any other table (triggers, views etc.) but the data that you insert into them persists only for the transaction or session (depending on the option set when you create the table).

An alternative for 8.0.5 with the object option installed is to use objects of type table

    'create type xyz as table of pqr;'

This is more restrictive, less intuitive, but can be made to work. There are a couple of examples on my website under PL/SQ and FEATURES.

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>>
>> someone wrote in message <7tkqs4$hog$1_at_nnrp1.deja.com>...
>> >I am some what new to Oracle. I have been working with SQL Server
>for
>> >the last couple of years and they have a feature that lets you create
>> >temporary tables on the fly.
>>
Received on Mon Oct 11 1999 - 09:28:28 CDT