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

From: Naveen Nahata <naveen_nahata_at_mindtree.com>
Date: Mon, 07 Oct 2002 07:59:32 -0800
Message-ID: <F001.004E245E.20021007075932@fatcity.com>

The table may not necessarily be truncated which depends on the setting whether it gets truncated on commit(or rollback) or at the end of the session. no other session can however see the data.

Regards
Naveen
-----Original Message-----
Sent: Monday, October 07, 2002 8:31 PM
To: Multiple recipients of list ORACLE-L

*Your session* should be able to see the rows. If you commit (or rollback) the table will be truncated. Are you commiting?

Lewis Bishop

---
Barclays Enable/ISS/OPTS - Oracle Database Consultant
Phone - 020 8298 3418
Mobile - 07950 380857
Email - lewis.bishop_at_woolwich.co.uk
 
-----Original Message-----
Sent: 07 October 2002 15:34
To: Multiple recipients of list ORACLE-L
 
This header confirms that this email message has been swept for the
presence of computer viruses. 

Corporate IT
THE WOOLWICH
----------------------------------------------------------------------
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----- 
Sent: Monday, October 07, 2002 9:43 AM 
To: Multiple recipients of list ORACLE-L 
 
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: Naveen Nahata
  INET: naveen_nahata_at_mindtree.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:59:32 CDT