Create the Nested Table
The following code creates a nested table and a storage table mytab for the nested table:
create type nt_rec as object (
lno number, -- line number
ltxt varchar2(80) -- text of line
);
create type nt_tab as table of nt_rec;
create table mytab (
id number primary key, -- primary key
dummy char(1), -- dummy column for indexing
doc nt_tab -- nested table
)
nested table doc store as myntab;