Tricks
Use SET DESCRIBE DEPTH ALL in
SQL*Plus to reveal all the fields in composite
datatype columns.
/*+
NESTED_TABLE_GET_REFS */ hint. Use at your own risk to directly query and
manipulate the contents of a nested table store table. Meant for
returning locators to large collections.
Instead of
local counters, use cursor%ROWCOUNT, coll.COUNT, coll.COUNT+1
or NVL(coll.LAST,0)+1 when looping, extending and populating collections.