oracle - "SQL command not properly ended" when using subquery -

i have following query working:

select      a.column_value artigo       encomenda e, table(e.artigos)       e.id = 2; 

this query returns following output (one row of type menu_t , of type bebida_menu_t). note isn't simple text, object of type defined myself, since object-relational database.

from result, want extract menu_t rows. so, i've tried following query:

select *  (select            a.column_value artigo                   encomenda e, table(e.artigos)        e.id = 2) subquery       subquery.artigo of (menu_t);  

which gives me error

933. 00000 - "sql command not ended"

and can't understand why.

update:

seems problem as keyword. so, should be:

select *  (select            a.column_value artigo                   encomenda e, table(e.artigos)        e.id = 2) subquery --removed 'as' here      value(subquery.artigo) of (menu_t); --added value() because inconsistent types 

however, getting error saying subquery.artigo invalid identifier.

904. 00000 - "%s: invalid identifier"

you need change:

where subquery.artigo of (menu_t); 

to

where subquery.artigo '%menu_t';