RE: View contents of global temp table

[Naveen Nahata]

Title: RE: View contents of global temp table

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----- From: Bishop Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 8:31 PM To: Multiple recipients of list ORACLE-L Subject: 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).