oracle nested tables example

oracle_nested_tables.sql

create or replace type id_list as table of number
/
create table test_nested(
  id   number primary key,
  ids  id_list
)
nested table ids store as nested_ids
/
insert into test_nested(id, ids)
values (1, id_list(1, 2, 3))
/

insert into test_nested(id, ids)
values (2, id_list(5, 7))
/

commit
/
create index nested_idx on nested_ids(column_value)
/

select *
from   test_nested
where  1 member of ids
/