Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Select-Into
Hi...
I am trying to do the following:
Select * into #temp from tblSomeTable;
Here #temp is a temporary table that I want Oracle to create once it execute this command. Since I am new to oracle and not sure if Oracle has temporary tables or not, Let me briefly explain what I expect.
I would want a table #temp to be created. The table can only be seen by me during the session it was created. Meaning, if I am logged into another machine, I should not be able to see the table on the 2nd machine. Also table should automatically be destroyed as soon as my session expires..
The above is a valid statement in SYBASE, and I am sure Oracle is a much powerful and advanced DBMS.
Would appreciate any help.
Thanks
Inder
Received on Fri Aug 13 1999 - 15:11:34 CDT