Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem: nested table of references

Re: Problem: nested table of references

From: <schaarsc_at_informatik.tu-muenchen.de>
Date: 1998/01/15
Message-ID: <69jm8a$8it$1@orthanc.reference.com>#1/1

 

> >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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US