When I simply try to retrieve all of the rows in my table EMPLOYEE
like this:
SELECT * FROM EMPLOYEE AS emp;
I get the following error:
ORA-00933: SQL command not properly ended 00933. 00000 - "SQL command not properly ended" *Cause: *Action: Error at Line: 14 Column: 11
If I remove the AS emp
it works just perfectly fine, but I want to rename my table here. Am I missing something totally obvious?
Advertisement
Answer
I believe that is a problem with your database engine. From the error i gather you are using Oracle. Oracle alias for tables is: table_name alias_name
(https://www.techonthenet.com/oracle/alias.php)
So change the query to:
SELECT * FROM EMPLOYEE emp;