Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: View contents of global temp table

RE: View contents of global temp table

From: Bishop Lewis <Lewis.Bishop_at_woolwich.co.uk>
Date: Mon, 07 Oct 2002 07:00:47 -0800
Message-ID: <F001.004E22BA.20021007070047@fatcity.com>


*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----- 
<mailto:Rick_Cale_at_teamhealth.com> ] 
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 <http://www.orafaq.com>
--
Author: INET: Rick_Cale_at_teamhealth.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com <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: Bishop Lewis INET: Lewis.Bishop_at_woolwich.co.uk 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:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US