Re: Temporary tables

Sorry, there is no such thing in Oracle. You have to specifically drop any table before you end session in order for it to be dropped.

SeeniRaj.K wrote:

> Can we create temporary tables in Oracle?
>
> Is there any concept like what we do in SYBASE?
> i.e. In SYBASE if we create a table starting with #, then that
> table will be
> treated as a temporary table.
> Is there anything like this ORACLE?
>
> Thanks in Advance,
> SeeniRaj.K
>
> --
> (@) (@)
> *
> \___/
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Vist me at : http://www.geocities.com/CollegePark/Campus/4239
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> SeeniRaj.K, Email : seeniraj_at_india.hp.com
> HP - ISOB, Phone : (91)(80)225-1554
> 29 Cunningham Road, Ext: 1132
> Bangalore - 560052. Fax : (91)(80)220-0196
> Karnataka.
> India.
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
Rick Muffler
Federal Express Corporation
719-262-1305