ORA-00965: column aliases not allowed for '*'



ORA-00965: column aliases not allowed for '*'..

Answer / guest

Cause: The statement is trying to alias the * expression in
the select list which is not legal.

Action: Remove the alias.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01033: ORACLE initialization or shutdown in progress

2 Answers  


O2I-00123: Unable to close the INITFILE file

1 Answers  


ORA-06559: wrong datatype requested, string, actual datatype is string

1 Answers  


RMAN-06584: WARNING: AS BACKUPSET option added due to allocation of multiple channel types

1 Answers  


ORA-01873: the leading precision of the interval is too small

1 Answers  






ORA-00202: controlfile: 'string'

1 Answers  


PCC-01512: Invalid EXEC SQL INCLUDE of file string found at line number in file string

1 Answers  


TNS-00235: Aborting connection: Protocol Apapter errors: string;number,number string;number,number

1 Answers  


TNS-12650: No common encryption or data integrity algorithm

1 Answers  


ORA-13115: [string]_EDGE$ table does not exist

1 Answers  


ORA-13054: recursive SQL parse error

1 Answers  


ORA-24340: cannot support more than 255 columns

1 Answers  


Categories