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:55:32 CDT