plsql - select forall array in sql statement(PL/SQL) -

type tabarray table of table%rowtype;  tablearray tabarray ;   --fill array   select *    bulk collect tablearray    table  table.field = ....  --work  pos in 1..tablearray .count  loop    dbms_output.put_line(pos||' '||audarray(pos).field);  end loop;  --doesn't work  select * table2   table2.field in (select filed forall tablearray ); 

main question: how can use array in sql statement (in) ?

first have create type in sql can use given below

 create type fruit_tt table of varchar2(100)  select column_value val   table(fruit_tt('apple','banana','apricot'))  column_value not 'a%'; 

here type fruit_tt created , using in sql query.