News for hackers. Stuff that matters.

A comment on Problems with Oracle SQL. Parent comment

Re:Problems with Oracle SQL by irrational on Friday September 10, 2021 @03:06PM (#28485774)
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.
[ Parent | on HN ]
Re:Problems with Oracle SQL by thornygreb on Friday September 10, 2021 @03:22PM (#28485937)
Exactly, and many features that are in the standard now and we take for granted were invented by Oracle in the first place.
[ Parent | on HN ]
Re:Problems with Oracle SQL by peapicker on Saturday September 11, 2021 @01:33AM (#28489644)
ANSI SQL is a supported option in Oracle since 9i.

Not that most Oracle DB ppl use it anyway.

[ Parent | on HN ]
Re:Problems with Oracle SQL by chasil on Friday September 10, 2021 @07:14PM (#28487916)
It would be ever so nice if Microsoft SQL Server supported JOIN USING in addition to JOIN ON.

Everybody has problems.

[ Parent | on HN ]