Posted by When you see this
SQL> with xyz
2 (
3 select 1 my_alias from dual
4 )
5 select * from xyz;
(
*
ERROR at line 2:
ORA-32033: unsupported column aliasing
your first thought might be that there is something wrong with the column alias “my_alias”.
In fact, it got nothing to do with that….its missing the “AS”.
SQL> with xyz as
2 (
3 select 1 my_alias from dual
4 )
5 select * from xyz;
MY_ALIAS
----------
1
Learning is not a spectator sport 
Interesting, I get another ORA-Exception:
sokrates@11.2 > with xyz
2 (
3 select 1 my_alias from dual
4 )
5 select * from xyz;
select 1 my_alias from dual
*
ERROR at line 3:
ORA-00904: : invalid identifier
which version are you on ?
Hi Matthias,
This particular database was 11.1.0.7