Re: How to query collection type's column?

"Dong-kyun Son" <tenbloodkr_at_hanmir.com> wrote in message news:b6tk92$nbq$1_at_news.kreonet.re.kr...
> i'm using oracle9i..
> i want to know how to query about collection index when i use collection
> type(VARRAY or NESTED TABLE)'s column.

<snip>

> I want to know how to query first author(-->'aaa') or second
> author(-->'bbb')... (with SQL Statement)

select

   a.COLUMN_VALUE
 from
   book b,
   TABLE(author) a
 where
   b.title = 'english';
/

if I got your question right (important pieces are uppercase).

-- 
Vladimir Zakharychev (bob_at_dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.