Re: Temp Tables?

Well.... I can think about these solutions...

1. Create a table dynamically whenever you need it and drop it when u done with this... U can wrap this code in a pl/sql procedure or whatever u may want...??? There is a overhead for the database to maintain consistency while creating this table...but if you can live with it...
2. Have a PL/SQL table of records.. First define a record type and then define a pl/sql table of that type. U got a array structure u can manipulate on the fly....

Rest is at Oracle's wish...

HTH. Aj

"Chris Totten" wrote in message ...
>Is there any way to create a temporary table that is only "visible" to the
>current session - a sort of work table?
>
>This sort of thing exists in both SQLS and INFORMIX but I've got a bad
>feeling Oracle has no equivalent support... :(
>
>Can anyone put my mind to rest on this - naturally we've used temp tables
>in a lot of places in our application with the other engines... :(
>
>If you have any help could you reply to the following e-mail address
>because I often miss posts on Usenet :
>
> mailto:chris_at_task.co.uk
>//chris
>
Received on Wed Jan 13 1999 - 17:36:28 CST