ORA-32033: unsupported column aliasing
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
ORA-02821: Unable to read the requested number of blocks.
ORA-38766: cannot flashback data file string; file resized smaller
PLS-00405: subquery not allowed in this context
ORA-12084: must use ALTER MATERIALIZED VIEW to alter "string"."string"
ORA-06606: LU6.2 Driver: Unexpected response from SNA
NZE-28819: No distinguished name provided.
ORA-23453: requested operation is not supported on top flavor
NNL-00892: Duplicate requests received: number
PLS-00496: too few columns in SELECT...INTO statement after bursting record targets
ORA-32301: object-relational materialized views must be primary key based
LSX-00024: unknown attribute group "~S"
ORA-32576: missing TYPE keyword