Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp tables?
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