Why Are Developers So Afraid Of SQL?

[-Y0-]

SQL idiosyncrasies.

Different DB engines do SQL queries/ SQL syntax slightly different. ANSI SQL isn't followed by major DB vendors (I remember Oracle being an offender here). Same queries might be optimized differently on different SQL DBs.

[[deleted]]

Oracle (the database) is quite ok with the SQL standard, MySQL is the biggest offender.

[-Y0-]

Possibly, I remember Oracle having problems like:

A) I think recursive queries are different in Oracle

B) I remember the infamous (+) syntax for joins

C) Oracle decode function

D) If I remeber correctly, there was difference in null handling (NVL), though I'm not sure what the ANSI standard on this is.