Re: add index on nested table

wangqunx_at_yahoo.com wrote:
> A newbie's question. How oracle add an index on nested table. F.g.
>
> Table Student:
>
> sid sname classes_registed{class_id, class_name}
> 01 marry {{c1, classA}, {c2,classB},{c3,classC}}
>
> Can Oracle add index between sid and class_id, so that if a query give
> c1, c2, or c3, I can locat 01's whole tuple??
>
> Thanks a lot.

http://tahti.oracle.com
http://asktom.oracle.com

You will find these web sites very useful.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)