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 - &...

Why do I get an Error when I try to rename a table after FROM?

When I simply try to retrieve all of the rows in my table EMPLOYEE like this:

SELECT *
FROM EMPLOYEE AS emp;

​x
 
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

 
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?

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;

 
SELECT *FROM EMPLOYEE emp;​

Advertisement

Answer