Re: Temp tables?
From: -=< a q u a b u b b l e >=- <no email>
Date: Sat, 6 Nov 1999 00:58:39 -0000
Message-ID: <7vvuft$pk4$1_at_news7.svr.pol.co.uk>
Date: Sat, 6 Nov 1999 00:58:39 -0000
Message-ID: <7vvuft$pk4$1_at_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 Sat Nov 06 1999 - 01:58:39 CET