Bunny. That command works the same in Oracle. The 'cursorname' is optional.

(PS. I have spent much time in Spanish Town)
>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%'