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

ORA-00965: column aliases not allowed for '*'
Cause: The statement is trying to alias the * expression in the select list which is  not legal.

Action: Remove the alias.