| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: View contents of global temp table
But when your session ends (for whatever reason) the data you created during the
session disappears for ever, so that each session sees the table as totally
empty at the beginning of the session.
Dick Goulet
____________________Reply Separator____________________ Author: "Naveen Nahata" <naveen_nahata_at_mindtree.com> Date: 10/7/2002 7:59 AM
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 RickReceived on Mon Oct 07 2002 - 12:04:04 CDT
--
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). <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:o = "urn:schemas-microsoft-com:office:office" xmlns:w = "urn:schemas-microsoft-com:office:word"><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <TITLE>RE: View contents of global temp table</TITLE> <META content=Word.Document name=ProgId> <META content="MSHTML 5.50.4208.1700" name=GENERATOR> <META content="Microsoft Word 10" name=Originator><LINK href="cid:filelist.xml_at_01C26E11.530EBF50" rel=File-List><!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> <STYLE>@font-face { font-family: Tahoma; } @font-face { font-family: Verdana; } @page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; mso-header-margin: 35.4pt; mso-footer-margin: 35.4pt; mso-paper-source: 0; } P.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } LI.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } DIV.MsoNormal { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } A:link { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlink { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } A:visited { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } SPAN.MsoHyperlinkFollowed { COLOR: blue; TEXT-DECORATION: underline; text-underline: single } P.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } LI.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } DIV.MsoAutoSig { FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman" } P { FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: "Times New Roman"; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto } CODE { FONT-FAMILY: "Courier New"; mso-fareast-font-family: "Times New Roman"; mso-ascii-font-family: "Courier New"; mso-hansi-font-family: "Courier New"; mso-bidi-font-family: "Courier New" } SPAN.EmailStyle19 { COLOR: navy; FONT-FAMILY: Arial; mso-ascii-font-family: Arial; mso-hansi-font-family: Arial; mso-bidi-font-family: Arial; mso-style-type: personal-reply; mso-style-noshow: yes; mso-ansi-font-size: 10.0pt; mso-bidi-font-size: 10.0pt } SPAN.SpellE { mso-style-name: ""; mso-spl-e: yes } SPAN.GramE { mso-style-name: ""; mso-gram-e: yes } DIV.Section1 { page: Section1 } OL { MARGIN-BOTTOM: 0cm } UL { MARGIN-BOTTOM: 0cm } </STYLE> <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--></HEAD> <BODY lang=EN-GB style="tab-interval: 36.0pt" vLink=blue link=blue> <DIV><SPAN class=042475614-07102002><FONT face=Arial color=#0000ff size=2>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.</FONT></SPAN></DIV> <DIV><SPAN class=042475614-07102002><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=042475614-07102002><FONT face=Arial color=#0000ff size=2>Regards</FONT></SPAN></DIV> <DIV><SPAN class=042475614-07102002><FONT face=Arial color=#0000ff size=2>Naveen</FONT></SPAN></DIV> <BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Bishop Lewis [mailto:Lewis.Bishop_at_woolwich.co.uk]<BR><B>Sent:</B> Monday, October 07, 2002 8:31 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: View contents of global temp table<BR><BR></FONT></DIV> <DIV class=Section1> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">*<B><SPAN style="FONT-WEIGHT: bold">Your session</SPAN></B>* should be able to see the rows. If you commit (or rollback) the table will be truncated. <SPAN style="mso-spacerun: yes"> </SPAN>Are you <SPAN class=SpellE>commiting</SPAN>?<o:p></o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <DIV> <P class=MsoAutoSig><FONT face=Verdana color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana; mso-no-proof: yes">Lewis Bishop<o:p></o:p></SPAN></FONT></P> <P class=MsoAutoSig><FONT face=Verdana color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana; mso-no-proof: yes">---<o:p></o:p></SPAN></FONT></P> <P class=MsoAutoSig><FONT face=Verdana color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana; mso-no-proof: yes">Barclays Enable/ISS/OPTS - Oracle Database Consultant<o:p></o:p></SPAN></FONT></P> <P class=MsoAutoSig><FONT face=Verdana color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana; mso-no-proof: yes">Phone - 020 8298 3418<o:p></o:p></SPAN></FONT></P> <P class=MsoAutoSig><FONT face=Verdana color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana; mso-no-proof: yes">Mobile - 07950 380857<o:p></o:p></SPAN></FONT></P> <P class=MsoAutoSig><FONT face=Verdana color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Verdana; mso-no-proof: yes">Email - lewis.bishop_at_woolwich.co.uk<o:p></o:p></SPAN></FONT></P></DIV> <P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"><o:p> </o:p></SPAN></FONT></P> <P class=MsoNormal><FONT face=Tahoma size=2><SPAN lang=EN-US style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma; mso-ansi-language: EN-US">-----Original Message-----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com] <BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> 07 October 2002 15:34<BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Multiple recipients of list ORACLE-L<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> RE: View contents of global temp table</SPAN></FONT></P> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P> <P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><CODE><FONT face="Courier New" size=3><SPAN style="FONT-SIZE: 12pt; mso-ansi-font-size: 12.0pt; mso-bidi-font-size: 12.0pt">This header confirms that this email message has been swept for the</SPAN></FONT></CODE><FONT face="Courier New"><SPAN style="FONT-FAMILY: 'Courier New'"><BR><CODE><FONT face="Courier New"><SPAN style="mso-ansi-font-size: 12.0pt; mso-bidi-font-size: 12.0pt">presence of computer viruses. </SPAN></FONT></CODE><BR><BR><CODE><FONT face="Courier New"><SPAN style="mso-ansi-font-size: 12.0pt; mso-bidi-font-size: 12.0pt">Corporate IT</SPAN></FONT></CODE><BR><CODE><FONT face="Courier New"><SPAN style="mso-ansi-font-size: 12.0pt; mso-bidi-font-size: 12.0pt">THE WOOLWICH</SPAN></FONT></CODE><BR><CODE><FONT face="Courier New"><SPAN style="mso-ansi-font-size: 12.0pt; mso-bidi-font-size: 12.0pt">----------------------------------------------------------------------</ SPAN></FONT></CODE></SPAN></FONT><o:p></o:p></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Rick,</SPAN></FONT> <o:p></o:p></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">it is like any other table ... if the data is committed and you have access you can see data, else no you can't.</SPAN></FONT> <o:p></o:p></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Raj</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">______________________________________________________</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Rajendra Jamadagni MIS, ESPN Inc.</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Rajendra dot Jamadagni at ESPN dot com</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. </SPAN></FONT><BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">QOTD: Any clod can have facts, but having an opinion is an art!</SPAN></FONT> <o:p></o:p></P> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">-----Original Message-----</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">From: Rick_Cale_at_teamhealth.com [<A href="mailto:Rick_Cale_at_teamhealth.com">mailto:Rick_Cale_at_teamhealth.com</A>]</S PAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Sent: Monday, October 07, 2002 9:43 AM</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">To: Multiple recipients of list ORACLE-L</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Subject: View contents of global temp table</SPAN></FONT> <o:p></o:p></P> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Hi All,</SPAN></FONT> <o:p></o:p></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">In session 1 I am loading data into a global temp table. Is there any way</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">to see contents of that table?</SPAN></FONT> <o:p></o:p></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Thanks</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Rick</SPAN></FONT> <o:p></o:p></P> <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">-- </SPAN></FONT><BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Please see the official ORACLE-L FAQ: <A target=_blank href="http://www.orafaq.com">http://www.orafaq.com</A></SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">-- </SPAN></FONT><BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">Author: </SPAN></FONT><BR><FONT size=2><SPAN style="FONT-SIZE: 10pt"> INET: Rick_Cale_at_teamhealth.com</SPAN></FONT> <o:p></o:p></P> <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Fat City Network Services -- 858-538-5051 <A target=_blank href="http://www.fatcity.com">http://www.fatcity.com</A></SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">San Diego, California -- Mailing list and web hosting services</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">---------------------------------------------------------------------</SPA N></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">To REMOVE yourself from this mailing list, send an E-Mail message</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">the message BODY, include a line containing: UNSUB ORACLE-L</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">(or the name of mailing list you want to be removed from). You may</SPAN></FONT> <BR><FONT size=2><SPAN style="FONT-SIZE: 10pt">also send the HELP command for other information (like subscribing).</SPAN></FONT> <o:p></o:p></P></DIV></BLOCKQUOTE></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: INET: dgoulet_at_vicr.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).
 |
 |