---

tags:

• database
• oracle
• plsql
• sql

---

Oracle plsql collection

Collection Comparison Associative Array Used in Language Index type Range Sparse Ordered When stored in a database table Usage pl/sQl only (alpha)numeric Unlimited–231+1 to 231–1 sparse Unordered n/a any set of data Nested Table Varray sQl and pl/sQl numeric Unlimited 1 to 231–1 initially dense / sparse after deletes Unordered out of line any set of data sQl and pl/sQl numeric limited dense ordered inline small sets of data