Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem: nested table of references
> >select deref(t) from the (select vals from logRecTable where id = 1) t
> > *
>
> Try select deref(t.column_value)
the subquery gives me a table of type:table of ref val
so there is no column in t except the reference it self,
but the column has no name.
trying to access some_text via t.some_text doesn't work either.
-- -------------------------------------------------------------------- Posted using Reference.COM http://WWW.Reference.COM FREE Usenet and Mailing list archive, directory and clipping service --------------------------------------------------------------------Received on Thu Jan 15 1998 - 00:00:00 CST