Search notes:

Oracle: Nested tables

Storing a nested table in a table

In order to store a nested table in a table, the table must be created with the nested table … clause:
create type t as table of number;
/

create table y (tt t)
  nested table tt -- Prevent ORA-22913: must specify table name for nested table column or attribute
  store as tt_n return as locator;

See also

Filling a nested table with execute immediate.
collection type

Index