(draft)
a. VARRAY (array)
- used when the number of elements are known beforehand
- if < 4kb : store inside table / if > 4kb outside the table, but same tablespace
- elements are retrieved all at once - therefore better choice when you need to do an operation at all elements at once
b. nested tables (sets and bags)
- sparse
c. associative arrays (hashtable)
(NT and AR are formerly known as index-by tables)
No comments:
Post a Comment