Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: temporary tables

Re: temporary tables

From: Emmanuel <zouzou_at_yahoo.com>
Date: 19 Jan 2000 11:12:04 GMT
Message-ID: <01bf6276$d0e69aa0$3601017e@EHM.cirra.fr>


I agree completely with this. Creating and dropping database objects creates a lot of system overhead !

Why not use views or dynamic views (select .... from (select ... from ..)).

Ed Prochak <prochak_at_my-deja.com> a écrit dans l'article <85tf39$210$1_at_nnrp1.deja.com>...
>
>
> 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 Wed Jan 19 2000 - 05:12:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US