Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

The problem is the Oracle dialect was created BEFORE the SQL standard was written. For backwards compatibility they never changed it after the SQL standard was written. Personally, I think they should have had a flag so you could choose whether to use standard SQL or Oracle SQL.


Exactly, and many features that are in the standard now and we take for granted were invented by Oracle in the first place.


ANSI SQL is a supported option in Oracle since 9i.

Not that most Oracle DB ppl use it anyway.


It would be ever so nice if Microsoft SQL Server supported JOIN USING in addition to JOIN ON.

Everybody has problems.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: