PL\/SQL<\/p>\n
\u2022new line char: ‘abc’ || chr(10) || ‘def’
\n\u2022escape char: ‘<\/p>\n
\u2022Nested Tables
\n-like one dimensional array but 1) has no upper bound; 2) is sparse (use buildin fxn NEXT to go to next subscript).
\n\u2022Index-by Tables
\n-like Nested Tables but
\n1) can Not be stored in database;
\n2) some collection methods (e.g. TRIM) only works on nested tables and varrays;
\n3) uninitialized. Nested tables are initialized to NULL.
\n4) PL\/SQL supports implicit datatype conversion between host arrays and index-by tables but not nested tables.<\/p>\n","protected":false},"excerpt":{"rendered":"
PL\/SQL \u2022new line char: ‘abc’ || chr(10) || ‘def’ \u2022escape char: ‘ \u2022Nested Tables -like one dimensional array but 1) has no upper bound; 2) is sparse (use buildin fxn NEXT to go to next subscript). \u2022Index-by Tables -like Nested … Continue reading