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: Richard Nield <richard.nield_at_ntlworld.com>
Date: Sun, 20 Jan 2002 19:28:59 -0000
Message-ID: <Y0F28.52019$Hg7.5646506@news11-gui.server.ntli.net>

"Daniel A. Morgan" <damorgan_at_exesolutions.com> wrote in message news:3C4A92E9.2E640F04_at_exesolutions.com...
> Don't be so quick to thank him. Oracle does not build temporary table as
you
> requested. That is SQL Server.
>
> Oracle's global temporary tables are a permanent part of the Oracle data
> dictionary. It is the rows in them that can either disappear after a
commit or
> disappear after a session: Something you determine when you define the
table.
> For example, the statement below, ON COMMIT PRESERVE ROWS deletes the rows
when
> the transaction ends.
>
> Read the manual or learn about how temp tables work in Oracle at
> http://technet.oracle.com.
>
> Daniel Morgan
>
>
>
>
> Richard Nield wrote:
>
> > Thanks...I'll go look.
> >
> > "pokalulu" <pokalulu_at_mindspring.com> wrote in message
> > news:a2cuq9$9aa$1_at_nntp9.atl.mindspring.net...
> > > Oracle can create temporary tables to hold
> > > session-private data that exists for the duration
> > > of a transaction or session.
> > >
> > > Example:
> > >
> > > CREATE GLOBAL TEMPORARY TABLE today_sales
> > > ON COMMIT PRESERVE ROWS
> > > AS SELECT * FROM orders WHERE order_date = SYSDATE;
> > >
> > > For more information:
> > >
> > > http://www.dbasupport.com/oracle/ora8/page2.shtml
> > >
> > >
> >

http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/st
> > > atements_73.htm#SQLRF01402
> > >
> > > Pokalulu-
> > >
> > >
> > >
> > > "Richard Nield" <richard.nield_at_ntlworld.com> wrote in message
> > > news:c1m28.85661$_x4.8486883_at_news2-win.server.ntlworld.com...
> > > >
> > > > Hi
> > > >
> > > > I seem to remember there is a way you can create a temporary table
> > that
> > > > disappears when the session ends. Is my memory right, and if can
> > someone
> > > > give me a hint on how to do this?
> > > >
> > > > many thanks!
> > > >
> > > > .
> > > >
> > > >
> > >
> > >
>
Received on Sun Jan 20 2002 - 13:28:59 CST

Original text of this message

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