Re: Select-Into

Oracle has temp tables, but not in the way that you describe. What you may actually be looking for is a view.

Can you explain what it is that you are trying to do?

"netnews.msn.com" wrote:

> 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 Mon Aug 16 1999 - 07:26:52 CDT