Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

TABLE VS NESTED TABLES

195382Apr 17 2002 — edited Feb 15 2007
I have a situation where I need to maintain multiple comments per row. The same row gets copied to a history table. In this case, if I were to maintain a sepearate table for comments then I need two table of comments. Instead I am planning to use nested tables feature. I know it looks like cumbersome way to insert and update nested tables. Does anyone know what are the advantages and disadvantages using separate table vs nested tables.

thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 15 2007
Added on Apr 17 2002
6 comments
773 views