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!

Nested Tables? Why do I need them?

452273Jul 13 2006 — edited Jul 13 2006

Hi! I am reading the PL/SQL reference about collections right now and I have reached the nested tables. And I can not understand the advantages of using them. There is an example there

INSERT INTO department
VALUES('English', 'Lynn Saunders', 'Breakstone Hall 205',
CourseList('Expository Writing',
'Film and Literature',
'Modern Science Fiction',
'Discursive Writing',
'Modern English Grammar',
'Introduction to Shakespeare',
'Modern Drama',
'The Short Story',
'The American Novel'));

So, what is the point of having nested table instead of two separate tables? I think it is a waste of memory, data duplication and problems related to it. Please tell me the real life example of useful use of nested tables. Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 10 2006

Added on Jul 13 2006

7 comments

624 views