From: yong321@yahoo.com
Newsgroups: comp.databases.oracle.misc
Subject: Re: Temporary Tables
Date: Fri, 02 Feb 2001 22:05:44 GMT
Organization: Deja.com
Lines: 27
Message-ID: <95favf$p52$1@nnrp1.deja.com>
References: <95f9pp$o1u$1@nnrp1.deja.com>
NNTP-Posting-Host: 163.188.121.48
X-Article-Creation-Date: Fri Feb 02 22:05:44 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.0; Windows NT; DigExt)
X-Http-Proxy: 1.1 x63.deja.com:80 (Squid/1.1.22) for client 163.188.121.48
X-MyDeja-Info: XMYDJUIDy0h8797


CREATE GLOBAL TEMPORARY TABLE ...

Yong Huang
yong321@yahoo.com

In article <95f9pp$o1u$1@nnrp1.deja.com>,
  brucescota@my-deja.com wrote:
> Hello,
>
> As of right now our database design has been designed to have a single
> user in which all web users will be using to access the database.  I
> need to create a set of stored procedures that access data from a
> temporary table.  The temp table will hold a set of ISBN's that will
 be
> used in a join with a titles table.  My question is: How can I create
 a
> unique table that the other users will not be able to see and update.
> In SQL server I could use Create #Temp and SQLServer would append a
> unique value to the end of #Temp and would drop the table after the
> connection to the database iwas dropped.  Is there any way to do this
> in ORACLE?  We are using ORACLE 8i
>
> scott


Sent via Deja.com
http://www.deja.com/