I remember there is a function to get a unique system-generated name for temporary table but don't know how.
Please let me know if someone knows.
Thanks.
Queyon
I remember there is a function to get a unique system-generated name for temporary table but don't know how.
Please let me know if someone knows.
Thanks.
Queyon
Use a sequence as part of the name?
What is the requirements for this? Would a Global Temporary Table work better?
I want to create a global temporary table but don't want to get any table name confict.
You could also use a timestamp:
;)PHP Code:Create Table MyTempTable_<YYMMDDHH24MISS>...
Why in the world would you want to go through the overhead of creating a temporary table when you can just use a GTT?Quote:
Originally Posted by Queyon
Read this very interesting article - it answers your question:Quote:
Originally Posted by Queyon
http://www.indiana.edu/~dss/Services...s/tmptabl.html
Do you know how GTT operates in Oracle?Quote:
Originally Posted by Queyon
Tamil
have to agree with that. trying to shoehorn somebody else's database on oracle. sometimes square pegs just don't fit into round holes no matter how big the hammer.Quote:
Originally Posted by tamilselvan
Hopefully nobody will attempt to do that operation twice in a second...Quote:
Originally Posted by LKBrwn_DBA
If you create a GTT you only do it once and and any name conflict you'd resolve then. GTT avoids the need to create a name dynamically.Quote:
Originally Posted by Queyon
No, I don't know how GTT operates in Oracle.Quote:
Originally Posted by tamilselvan
Could you describe?
Thanks.
Look under "Managing temporary tables" here:
http://download-uk.oracle.com/docs/c...03sch.htm#7794