From: brucescota@my-deja.com
Newsgroups: comp.databases.oracle.misc
Subject: Temporary Tables
Date: Fri, 02 Feb 2001 21:45:32 GMT
Organization: Deja.com
Lines: 18
Message-ID: <95f9pp$o1u$1@nnrp1.deja.com>
NNTP-Posting-Host: 192.190.16.51
X-Article-Creation-Date: Fri Feb 02 21:45:32 2001 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
X-Http-Proxy: 1.1 x62.deja.com:80 (Squid/1.1.22) for client 192.190.16.51
X-MyDeja-Info: XMYDJUIDbrucescota


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/