ORA-32033: unsupported column aliasing

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

2 thoughts on “ORA-32033: unsupported column aliasing

  1. 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 ?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s