Re: Howto Create global temporary table in Oracle 8.0.5

On 14 Dec 2005 14:55:08 -0800, "degelis" <claudedube_at_gmail.com> wrote:

>I need it for a trigger
>I want to save some values < before delete > into a table
>and then reuse those values <after delete >
>I use a temporary table in oracle 9.2.0,
>I have to do the same trick in oracle 8.0.5.
>
>Do you know another way for oracle 8.0?

Your solution to use a temporary table in 9.2 is appalling as you can quite nicely do this with collections.

Collections might exist in 8.0
But evidently the best other way is to dump paleolithic releases in favor for something current (and supported)

--
Sybrand Bakker, Senior Oracle DBA