Re: Is there anything called session specific tables

Do any of you people work on Oracle 11i and Oraclce Reports 6i and Forms 6i and Oracle Portals? I need someone with that background for my company in Des Moines, IA. Let me know. Thanks Dick Vander Laan also rvanderl_at_ifmc.org email at work. Thank again
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, March 16, 2001 7:26 AM

> Tapas,
>
> If you're on 8i (I don't think they're available on 8.0, but
> not sure), look at Global Temporary Tables. They are
> permanently defined in the data dictionary so triggers and
> packages and views, etc. can reference them, but the rows
> inserted, updated, and deleted in them are visible only to
> the session(s) acting on them. Those rows are automatically
> deleted at the end of the session or the end of each
> transaction, depending on how you create the tables. Very
> nice feature.
>
> Jack
>
> --------------------------------
> Jack C. Applewhite
> Database Administrator/Developer
> OCP Oracle8 DBA
> iNetProfit, Inc.
> Austin, Texas
> www.iNetProfit.com
> japplewhite_at_inetprofit.com
>
>
> -----Original Message-----
> tapas dutta
> Sent: Friday, March 16, 2001 1:36 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello Listers,
>
> 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
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: tapas dutta
> INET: tapasoracle_at_umtl.co.in
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jack C. Applewhite
> INET: japplewhite_at_inetprofit.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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Richard T. Vander Laan
  INET: rvander_at_lisco.net

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).