29
of 53
More About Nested Tables
u
Nested tables can be used in SQL queries with
the special operator: TABLE
Ø
Allows hiding of complex procedural logic “under
the hood”
Ø
Nested table type must be declared as a user-defined
type (CREATE OR REPLACE TYPE…)