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!

clearity between nested table vs associative array

685758Apr 10 2012 — edited Apr 10 2012
hi all,
please tell me difference between nested table vs associative array as per below statement.

1.Nested tables can be stored in a database column, but associative arrays cannot.
2.Associative arrays are appropriate for relatively small lookup tables where the collection can be constructed in memory each time a procedure is called or a package is initialized.

please make me comfortable with above points with examples so that i can actually understand both.


rgds,
pc
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2012
Added on Apr 10 2012
6 comments
12,177 views