create type type_array is varray(10) of varchar2(20);

create table z_t_array(col1 type_array);  
 
insert into z_t_array values(type_array('YWQNG','XTGLG'));

select * from Z_T_ARRAY t;

select * from table(select t.col1 from Z_T_ARRAY t);