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

Home -> Community -> Usenet -> c.d.o.server -> Re: IN Subquery on Collection

Re: IN Subquery on Collection

From: m.t <mt_at_matelot.com>
Date: Thu, 1 Feb 2007 10:35:48 -0500
Message-ID: <12s426m2kqvdv9b@corp.supernews.com>

"Maxim Demenko";
>>
>
> You can select only from unnested (table expression) collection (at least
> in 10gR2) . Collection should be an SQL datatype ( as opposite to PL SQL
> datatype).
> There are tons of examples in pl sql developer quide ,sql reference and
> app dev guide - oo features.
> http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14261/tuning.htm#sthref2241
> http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14260/adobjcol.htm#sthref481
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2071637
>

thanks
So there is NO WAY Assoc-Array/Index-by Table can be used in this fashion , correct ? Received on Thu Feb 01 2007 - 09:35:48 CST

Original text of this message

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