Re: temporary tables

But using CREATE/DROP of temporary tables is overkill in many situations.

Does Mike really need a table that can be queried? Or do you just need temporary storage, like an array. Look into PL/SQL arrays. I cannot give an example today, but check you PL/SQL references. The arrays work just like a sparse array, can hold records from queries. Only thing you cannot do is put it in an SQL query (cannot SELECT FROM it.) No need to worry about naming conflicts either!

So rather than forcing SQL Server or Informix methods into your Oracle procedures, why not describe the real problem you are seeking to solve? then we can suggest how best to solve it in Oracle.

In article <3880E4B2.2D4AA619_at_rdbms.freeserve.co.uk>,   "Christopher M. Day" <christopher.day_at_rdbms.freeserve.co.uk> wrote:
> Mike,
>
> Temporary tables managed by the database are introduced in Oracle8i.
>
> So in 7.3.4 we have to manage our own using CREATE TABLE xx AS ..
where
> xx is our unique generated table name. Remember to use the storage
> clause...
>
> Chris.
>
> I remember being able to do this in Informix 2.1 10 years ago ....
>
> trumpet999_at_my-deja.com wrote:
> >
> > How do you create a temporary table within a stored procedure? I
> > remember being able to do this in SQL Server but I cannot find a way
> > to do it in Oracle v 7.3.4.
> >
> > Can someone post an example ?
> >
> > Thanks.
> >
> > Mike

--
Ed Prochak
Magic Interface, Ltd.
ORACLE Development, conversions, training and support 440-498-3700 magic_at_interfacefamily.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sun Jan 16 2000 - 16:01:19 CST