ORA-32033: unsupported column aliasing

Question Posted / guest

3 Answers
18154 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

ORA-32033: unsupported column aliasing..

Answer / bunditj

The database version is major problem. Using a column alias on subquery factoring, it is not allowed on 10g, but practical to 11g onwards.

Is This Answer Correct ?

3 Yes

0 No

ORA-32033: unsupported column aliasing..

Answer / dhanabalan

ORA-32033: unsupported column aliasing
32033. 00000 - "unsupported column aliasing"
*Cause: column aliasing in WITH clause is not supported yet
*Action: specify aliasing in defintion subquery and retry

WITH Numbers(n) AS
(
SELECT 1 AS N
FROM dual
UNION ALL
SELECT N + 1 AS N
FROM Numbers
WHERE N < 9
)
SELECT *
FROM Numbers;

Is This Answer Correct ?

1 Yes

1 No

ORA-32033: unsupported column aliasing..

Answer / guest

Cause: column aliasing in WITH clause is not supported yet

Action: specify aliasing in defintion subquery and retry

Please add more information about this Error

Is This Answer Correct ?

4 Yes

6 No

Post New Answer