drop type var_tbl;
/
drop table nested_table;
/
create type var_tbl is table of varchar2(10);
/
CREATE TABLE nested_table (col1 var_tbl)
       NESTED TABLE col1 STORE AS col1_tab;
/
insert into nested_table (col1) values (var_tbl('a', 'b', 'c', 'd'));
commit;
/
select b.column_value from nested_table a inner join table (col1) b on 1=1
order by b.nested_table_id desc;

1 d
2 c
3 b
4 a

/
declare
v var_tbl := var_tbl();
begin
select b.column_value bulk collect into v
from nested_table a inner join table (col1) b on 1=1;
order by b.nested_table_id desc;
dbms_output.put_line(v(1));
end;

ORA-00904: "B"."NESTED_TABLE_ID": invalid identifier

declare
v var_tbl := var_tbl();
begin
select b.column_value bulk collect into v
from nested_table a inner join table (col1) b on 1=1
order by b.nested_table_id desc;
dbms_output.put_line(v(1));
end;