3 ms·
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
by irrational 5y ago
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.
- thornygreb 5y agoExactly, and many features that are in the standard now and we take for granted were invented by Oracle in the first place.
- chasil 5y agoIt would be ever so nice if Microsoft SQL Server supported JOIN USING in addition to JOIN ON. Everybody has problems.
- peapicker 5y agoANSI SQL is a supported option in Oracle since 9i. Not that most Oracle DB ppl use it anyway.