Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: temporary tables
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 Sat Jan 19 2002 - 17:31:38 CST