Oracle Table Variable

1. Select as table 

select * from table(var_tab)

2. Convert column to table and join parent table

select b.* from aud_item a join table(a.log) b on 1=1 where rownum<10

log column: table of following type

-------------------------

create or replace type "my_table_type" AS VARRAY(100000000) of t_another type