Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-32033: unsupported column aliasing
- 3 Answers
- 18964 Views
- I also Faced
- E-Mail Answers
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 |
NZE-28802: invalid mode or data source in configuration file
ORA-16051: parameter string contains an invalid delay time
ORA-29337: tablespace 'string' has a non-standard block size (string)
QSM-01012: SAMPLE clause present in FROM
ORA-28046: Password change for SYS disallowed
TNS-12596: TNS:internal inconsistency
ORA-06011: NETASY: dialogue too long
ORA-13402: the rasterType is null or not supported
ORA-16041: Remote File Server fatal error
PCB-00004: UNSAFE_NULL=YES must be used with DBMS=V7 or V8 and MODE=ORACLE
ORA-12719: operation requires database is in RESTRICTED mode
ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string
Oracle Errors 
