Following query gives me an error:

"ORA-32034: Unsupported use of WITH clause"

 WITH table_B as 
(
    SELECT * FROM (
        WITH table_A AS
            (SELECT 'Akshay' as NAME FROM DUAL)
        SELECT NAME FROM table_A
    ) WHERE NAME LIKE '%Aks%' ---<<< Note a filter here
)
SELECT * from table_B;

Is there a way out? Thanks