Re: Can I create temp table for my session only?

I don't know about automatic dropping of the table when the connection is dropped but normally the way that you do this is execute some dynamic sql to create the table for you when you start up your application (e.g. use BEFOREREPORT trigger in REPORTS v2.5) and drop or TRUNCATE the table when your application exits (AFTERREPORT trigger). In FORMS there are similar event triggers that you can use to give you a similar effect to the one you describe.

Hopes this helps!

Mike Campbell

U95NKM <U95NKM_at_cis.hkuspace.org> wrote in article <3475E72B.4C9803E1_at_cis.hkuspace.org>...
> Hi,
>
> I would like to know can I create a temp table similar to temp table
> in MS-SQL and Sybase, when the connection lost the table will be delete
> automatically. Or is there any substitution for it?
>
> It is because I my migrating my system from MS-SQL to Oracle 8 while
> one of the vital function is utilising the temp table to notify the
> existence of the program.
>
> Thank you for your attention.
>
> Kevin
>
>
  Received on Sat Nov 22 1997 - 00:00:00 CET