Re: Temp tables?

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Sat, 6 Nov 1999 00:58:39 -0000
Message-ID: <7vvuft$pk4$1@news7.svr.pol.co.uk>

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?

To clarify a previous reply by someone else, you need to use a pl/sql table using a %ROWTYPE datatype. You can then reference this using dot notation and a subscript. i.e. my_table.my_field[row_number].

HTH Received on Fri Nov 05 1999 - 18:58:39 CST