By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with t (a) as (select 1 from dual)
select (select * from (select a from dual))
from t;
ORA-00904: "A": invalid identifier
ORA-00904: "A": invalid identifier