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" <[EMAIL PROTECTED]>
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 - [EMAIL PROTECTED]
 
-----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 
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). 

<!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:[EMAIL PROTECTED]"; 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>&nbsp;</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:[EMAIL PROTECTED]]<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">&nbsp;</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>&nbsp;</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&nbsp;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 
  - [EMAIL PROTECTED]<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>&nbsp;</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:[EMAIL PROTECTED]] <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>&nbsp;</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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 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>&nbsp;</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: [EMAIL PROTECTED] [<A 
  href="mailto:[EMAIL PROTECTED]";>mailto:[EMAIL PROTECTED]</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>&nbsp;</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.&nbsp; 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>&nbsp;</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">&nbsp; INET: [EMAIL PROTECTED]</SPAN></FONT> 
  <o:p></o:p></P>
  <P><FONT face="Times New Roman" size=2><SPAN style="FONT-SIZE: 10pt">Fat City 
  Network Services&nbsp;&nbsp;&nbsp; -- 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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- 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: [EMAIL PROTECTED] (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).&nbsp; 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: [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).

Reply via email to