SQL select from table with alias (Oracle9i) -

SQL select from table with alias (Oracle9i) -

according oracle documentation statement select should possible alias table names aliases without or keyword as. however, aliasing tables keyword as leads error:

ora-00933: sql command not ended

for example, next statement fails above error:

select count(*) my_table a;

once keyword as removed executes expected.

could please comment on this. there way create application of as table aliasing work?

p.s. i'm using code generation utility translate java code sql statements @ runtime. utility enforces utilize of aliases as.

oracle not take table aliases , see no way create work.

can't in java? column aliases optional in oracle, " " in generated string , remove them (thus removing column aliases table aliases). option?

sql oracle9i