According to Oracle documentation for statement
SELECT it should be possible to alias table names with aliases without or with keyword
AS. However, aliasing tables with keyword
AS leads to error:
ORA-00933: SQL command not properly ended
For example, the following statement fails with the above error:
SELECT COUNT(*) FROM MY_TABLE AS A;
AS is removed it executes as expected.
Could anyone please comment on this. Is there a way to make the application of
AS for table aliasing work?
P.S. I'm using a code generation utility that translate some Java code into SQL statements at runtime. This utility enforces the use of aliases with