Re: Nested Tables in Oracle

Ritesh Kachhwaha wrote:

> Hello All,
>
> Can anyone please explain to me why you would need to use Nested tables and
> give an example. Also can you show the SQL to view the table and the nested
> table and explain the logic of it.
>
> Thanks in advance for your help.

Michel is correct about finding syntax and examples at tahiti and I would suggest you also look at http://asktom.oracle.com.

With respect to the rest of your question. Need to? Never. Want to ... if working with an object-oriented front-end though I prefer object views.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)