ORA-00965 : column aliases not allowed for ‘*’

Email This Post Email This Post

Cause : An alias was used with the return-all-columns function (*) in the
SELECT list. For example:

SELECT * COL_ALIAS FROM EMP;

Action: Either specify individual columns or do not specify an alias with a “*”.

Popularity: 2% [?]

Related Post

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>

Close
E-mail It