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-16529: bad sender id

1 Answers  


RMAN-06710: script string not found in catalog

1 Answers  


ORA-04088: error during execution of trigger 'string.string'

1 Answers  


ORA-12079: materialized view options require COMPATIBLE parameter to be string or greater

1 Answers  


ORA-29909: label for the ancillary operator is not a literal number

1 Answers  






ORA-00231: snapshot controlfile has not been named

1 Answers  


SQL*Loader-00307: Warning: conflicting lengths number and number specified for column string table string

1 Answers  


TNS-01182: Listener rejected registration of service "string"

1 Answers  


ORA-01271: Unable to create new file name for file string

1 Answers  


NNO-00613: disabling FORWARDING-DESIRED on system queries

1 Answers  


ORA-30738: object "string" does not exist in schema "string"

1 Answers  


NID-00002: Parse error: string

1 Answers  


Categories