Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to get unique temp table name

How to get unique temp table name

From: ian <ipellew_at_yahoo.com>
Date: 13 Oct 2006 05:53:08 -0700
Message-ID: <1160743987.957069.39190@m7g2000cwm.googlegroups.com> 





Hi;



What is the method in <SQL*Plus: Release 8.1.7.0.0> to create a unique
temporary table name.



I "create global temporary something(whatever);" and I see it lives for
the world.


This site has every one using the same administration login, as far as
I know its the only one!



I guess this is going to come out as a 'define tt = random(1)' type
answer.



Regards


Ian
Received on Fri Oct 13 2006 - 07:53:08 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US