Re: Temprorary Tables

Leng Kaing wrote:
>
> L. Tseng (lesliet_at_u.washington.edu) wrote:
> : Would you mind sharing some thoughts about how to create
> : a temp table in a procedure, populate it, loop thru it, and
> : then drop it? Thank you,
> : Lesliet
>
> Use dbms_sql. I've used this for create users and should work for
> create tables. Lately I've also heard that of dbms_ddl which should
> allow for DDLS's. Haven't tried this myself.
>
> Leng.
>
> --
> Leng Kaing - Database Consultant
> Common Sense Consulting
> Phone: +61-3-9885-5829 (ext 46)
> Email: leng_at_comsense.com.au
> WWW: http://dingo.vut.edu.au/voug

Hi. as I wrote to Bobby V. here above:

What we do, when we need a temporary table is, that we have a "permanent" table, but we never commit any insert, update or delete. In this way every change to the table is temporary. You can have several clients to use the table simultanously and everyones changes are only reflected to his own session. The procedure rolls back the changes to the table before it ends.

BUT!!!
Very often people are using temporary tables in PL/SQL, because they do not know a better way to make more complicated things in SQL than standard functions. If you want, let me analyze your actual problem. There might be an alternativ to writing a temporary table, that would be MUCHO, MUCHO, MUCHO faster.

Regards Tony Received on Sun Dec 01 1996 - 00:00:00 CET