PL/SQL
•new line char: ‘abc’ || chr(10) || ‘def’
•escape char: ‘
•Nested Tables
-like one dimensional array but 1) has no upper bound; 2) is sparse (use buildin fxn NEXT to go to next subscript).
•Index-by Tables
-like Nested Tables but
1) can Not be stored in database;
2) some collection methods (e.g. TRIM) only works on nested tables and varrays;
3) uninitialized. Nested tables are initialized to NULL.
4) PL/SQL supports implicit datatype conversion between host arrays and index-by tables but not nested tables.