Re: Newbie question

From: Norris <johnnie_at_cooper.com.hk>
Date: 13 Sep 1999 05:32:14 GMT
Message-ID: <7ri28u$1n6g$2@adenine.netfront.net>

What is the difference between 'virtual' table and 'real' table?

Rod Stewart <rod.stewart_at_afp.gov.au> wrote:

> Oracle only has temporary tables in the way I suspect you mean under version
> 8.1.5 and upwards (I think, I could be wrong!).  Another way you could do it
> would be to use a 'virtual' table within a PL/SQL procedure or function.

> HTH > Rod J. Stewart

> Alex Daman <alex_damanakis_at_exe.com.au> wrote in message
> news:xe_C3.13019$1E2.90490_at_ozemail.com.au...

>> Hello All,
>>
>> I want to know if there is a way to select data into a temporary table.
>>
>> For example :
>>
>> select * from my_table
>> into temp my_temp_table.
>>
>> The temporary table should only exist for the duration of the session. I
>> know with other database products you can do the above. I suppose I am
>> looking for the equivalent for Oracle.
>>
>> Thanks in advance,
>>
>> Alex
>>
>>
>>

--
Have several nice days...

---

Opinions are mine and do not necessarily reflect those of the Corp.

http://www.ntfaq.com

http://www.jsiinc.com/reghack.htm

http://www.oconnell.net/Sybase_FAQ

http://www.cyberport.com/~tangent/programming/winsock/

===================================================================

Received on Mon Sep 13 1999 - 00:32:14 CDT