Re: temporary tables

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 - 03:50:33 CST