tables and associative arrays formerly known as index by tables use similar The Open Group Certification subscript notation, but they have different characteristics when it comes to persistence and ease of parameter passing. Nested tables can be stored The Open Group Certification it exam in a database column, but associative arrays cannot. Nested tables are appropriate for important data relationships that must be stored persistently. Associative The Open Group Certification 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. They are good for collecting information whose volume is unknown beforehand, because there is no fixed limit on their size. Their index values are more flexible, because associative array subscripts can be negative, can be nonsequential, and can use string values instead of numbers when appropriate. PL SQL automatically converts between host arrays and associative arrays that use numeric key values. The most efficient way to pass collections to and from the database server is to use anonymous PL SQL blocks to bulk bind input and output host arrays to associative arrays. Choosing Between Nested Tables and Varra.