Re: Temporary tables in Oracle

Randy DeWoolfson <randyd_at_cais.com> wrote in article <342EC0B9.187D_at_cais.com>...
> > snip
> >
> > But then he could create temporary tables the same way he did in
> > Informix and then explicitly delete them when he was through with
> > them. I agree it isn't as neat a solution as Informix has, but
> > adding "DROP TABLE temp;" at the appropriate time and place doesn't
> > strike me as being too much of a hardship :-)

coding a create or drop table is a real hassle in pl/sql (you will have to use the dbms_sql package for this). further, i think your package/procedure/trigger/function will be invalidated by oracle when one of the tables it depends on (temp) is dropped.

> >
> > Jerry
>
> plus...
>
> if you dont commit in between, the create of the temp object
> and the drop, then no other user can see it, and it in effect
> is your own personal version of the table.
>

issueing a DDL statement will automatically COMMIT your transaction.

> randy

i think the best solution is to create a 'permanent' table with the userid (or sessionid) as part of the key.

gert Received on Mon Sep 29 1997 - 00:00:00 CDT