Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table mytable (id) as select 12345 from dual
1 rows affected

WITH fake_query_with AS 
(
   SELECT "ID" 
   FROM "MYTABLE" 
   WHERE "ID"=12345
) 
SELECT "fake_query_with".* 
FROM fake_query_with
ORA-00904: "fake_query_with": invalid identifier

WITH FAKE_QUERY_WITH AS 
(
   SELECT "ID" 
   FROM "MYTABLE" 
   WHERE "ID"=12345
) 
SELECT "FAKE_QUERY_WITH".* 
FROM FAKE_QUERY_WITH


ID


12345