Re: Is there anything called session specific tables

From: yong huang <yong321_at_yahoo.com>
Date: Fri, 16 Mar 2001 13:21:19 -0800
Message-ID: <F001.002CF6C2.20010316125035@fatcity.com>

Hi, Tapas,

It's called TEMPORARY TABLE (reserved words). Create them by CREATE GLOBAL TEMPORARY TABLE. Yong Huang
yong321_at_yahoo.com

you wrote:

I am facing a typical problem. In one of my D2K appliaction I need to first populate the data in a particular itermediate table and then run the reporting job. The data population has been done in the report trigger. But the problem is if at the same time another user fires the same report, the data population becomes erroneous as he is also sharing the same table.

Is there any concept of session specific tables.

Please help.
Regards,

Tapas

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: yong huang
INET: yong321_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Fri Mar 16 2001 - 15:21:19 CST