Create an alias for the @DerivedTable function

[first_last]

Is it possible to create an alias for the @DerivedTable function when it is being referenced in another derived table?

DT_FOO:

SELECT  *
FROM    schema.table_foo

DT_BAR:

SELECT  foo.*
FROM    @DerivedTable(DT_FOO) AS foo

Generates a missing right parentheses error when used in Oracle.

[first_last]

One solution:

SELECT  foo.*
FROM  ( SELECT * FROM @DerivedTable(DT_FOO) ) AS foo