Tips
Use aliases
for the tables and nested tables when unnesting
Treat a nested
table as a normal child table in joins
Ensure
collection has content before accessing it
Use
coll.FIRST..coll.LAST, not 1..coll.COUNT
Use RETURN AS
LOCATOR if collection is large and accessed infrequently
Use a column
alias for COLUMN_VALUE when unnesting anonymous collections
Index
associative arrays using PLS_INTEGER and %TYPE