Oracle-L: Re: View contents of global temp table

From: <Rick_Cale_at_teamhealth.com>
Date: Mon, 07 Oct 2002 07:24:06 -0800
Message-ID: <F001.004E2363.20021007072406@fatcity.com>

You are correct. You can only see data for that session if you perserve rows

Rick

                                                                                             
                    "Igor Neyman"                                                            
                    <ineyman_at_perce       To:     Multiple recipients of list ORACLE-L        
                    ptron.com>            <ORACLE-L_at_fatcity.com>                             
                    Sent by:             cc:                                                 
                    root_at_fatcity.c       Subject:     Re: View contents of global temp table 
                    om                                                                       
                                                                                             
                                                                                             
                    10/07/2002                                                               
                    11:00 AM                                                                 
                    Please respond                                                           
                    to ORACLE-L

I'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: 
  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).

Received on Mon Oct 07 2002 - 10:24:06 CDT