Re: View contents of global temp table

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 07 Oct 2002 07:00:50 -0800
Message-ID: <F001.004E22F0.20021007070050@fatcity.com>

RE: View contents of global temp tableI'd disagree. I've always thought, that you can only see your "own" data in temp table, and not "other session" data. You share only table definition (not contents) with other sessions.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com   

• Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Monday, October 07, 2002 10:33 AM Subject: RE: View contents of global temp table

  Rick,

  it is like any other table ... if the data is committed and you have access you can see data, else no you can't.

  Raj

---

  Rajendra Jamadagni MIS, ESPN Inc.   Rajendra dot Jamadagni at ESPN dot com   Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.   QOTD: Any clod can have facts, but having an opinion is an art!

  -----Original Message-----
  From: Rick_Cale_at_teamhealth.com [mailto:Rick_Cale_at_teamhealth.com]   Sent: Monday, October 07, 2002 9:43 AM   To: Multiple recipients of list ORACLE-L   Subject: View contents of global temp table

  Hi All,

  In session 1 I am loading data into a global temp table. Is there any way   to see contents of that table?

  Thanks
  Rick

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

  Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
  San Diego, California        -- Mailing list and web hosting services 
  --------------------------------------------------------------------- 

  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: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

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 Mon Oct 07 2002 - 10:00:50 CDT