RE: View contents of global temp table

[Bishop Lewis]

Title: 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 - [EMAIL PROTECTED]   -----Original Message----- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 15:34 To: Multiple recipients of list ORACLE-L Subject: RE: View contents of global temp table   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----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).