oracle11g - In Oracle "AS" alias not working

Question

Just want to know why Oracle not allowed "AS" alias in Query. In My project all queries which i returned have alias keyword "AS".

For.eg;

Select t1.id,t2.name from Table1 As t1 ,Table2 t2 
on
  t1.id =t2.id

above Query run in all Server like PostgreSQL ,Microsoft SQL server but in Oracle its Not working showing error "Command does not exists" because of alias "As". If i remove then it will run.

just want to know why Oracle Server behave like this ? i want to run query using "AS"alias name.

Answer 1

While Oracle allows you to use AS when defining column aliases, it doesn't allow you to use AS when defining table aliases. It's just how Oracle works.