Oracle - ORA00933: SQL command not properly ended

 If you encounters 

ORA00933: SQL command not properly ended

something is wrong with you SQL.

One place I was hit by this error is when I use SQL that works with PostgreSQL on Oracle. Especially, on table alias

On Oracle, the following syntax apply when have table alias

- You can use "select abc as efg  ... " on result column

- However, you CANNOT use "select * from abc as efg ..." on table name. This will result in error. Oracle syntax is "select * from abc efg ..."

Below is a list of Oracle compliance feature

https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/Oracle-Compliance-To-Core-SQL2011.html#GUID-D372D906-805B-49B8-824A-D4697B05B7F8