35
of 62
More About Nested Tables
u
Nested tables can be used in SQL queries via 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…)