Whats the equivalent of the temp table and derived table in Oracle ?

Can the following command work in Oracle as in SQL Server ?

Select fld1, fld2
from ( Select * from somefile where fld='XXX' ) cursorname
where fld1 like 'yyyy%'
and fld2 like 'zzzz%'