Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: View contents of global temp table
*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 RickReceived on Mon Oct 07 2002 - 10:00:47 CDT
--
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).
![]() |
![]() |