Re: Temp tables?

If you are one version 8.0 (rather than 8.1) then an object table-type is probably the best thing (there a couple of examples on my web site) since you can cast between an object table and a cursor very easily.

8.1 has 'proper' temporary tables.
7.3 has the PL/SQL, which is a pain and CPU intensive if you want to 'select from it' (also on my web-site)

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Richard J Woodland wrote in message
<38234EEB.54CE1A07_at_interfacefamily.com>...
>Then perhaps PL/SQL tables would do the job?
>
>
>Chad Sheley wrote:
>
>> I should have been more specific.
>>
>> I really want to create an in memory table of the rows that I create. A
view
>> can't do this.
>>
>> Chad Sheley
>> csheley_at_usa.capgemini.com
>> Senior Consultant
>> Cap Gemini
>> Des Moines, IA
>>
>> Alan Shein wrote in message <7vv3b9$9aa$1_at_autumn.news.rcn.net>...
>> >VIEWS
>> >
>> >Chad Sheley <csheley_at_usa.capgemini.com> wrote in message
>> >news:2fEU3.175$c96.15362_at_news.uswest.net...
>> >> This may be a stupid question, but I can't seem to find the concept of
an
>> >> Oracle temporary table in any documentation. Is there a reason? or am
I
>> >just
>> >> a poor researcher?
>> >>
>> >> Chad Sheley
>> >> csheley_at_usa.capgemini.com
>> >> Senior Consultant
>> >> Cap Gemini
>> >> Des Moines, IA
>> >>
>> >>
>> >
>> >
>
Received on Sat Nov 06 1999 - 02:39:32 CST