Learning is not a spectator sport

ORA-32033: unsupported column aliasing

1–2 minutes

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 responses to “ORA-32033: unsupported column aliasing”

  1. Matthias Rogel Avatar
    Matthias Rogel

    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 ?

    Reply
  2. connormcdonald Avatar
    connormcdonald

    Hi Matthias,

    This particular database was 11.1.0.7

    Reply

Got some thoughts? Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Trending