I've been working with Oracle SQL for years, and it definitely has it's idiosyncrasies. Part of their problem is (in my opinion) an unwillingness to upgrade older programs and processes. I do a lot of work in Pro*C, which is C with pre-compiled Oracle SQL and PL/SQL embedded in normal C code. The SQL you can use in that tool, for some reason, is a small subset of what you can use in an SQL tool like PL/SQL Developer. You can't bring back subselects in the select list, and you can't use inline views, among others. Which baffles me, because it should all be SQL once you hit their database.
Their sqlplus command-line tool for linux program was written in 1982 it says, and it still doesn't allow for use of the up arrow to retrieve history, and is very quirky with how it handles editing of code. Their Oracle Forms product is very klunky, too. I'm happy I don't need to set up Web Logic servers, because that looks like a nightmare, too.
A little work on tooling would go a long way.
I am partial to using joins in where clauses instead of ansi sql join statements, so I guess there's that.
Their sqlplus command-line tool for linux program was written in 1982 it says, and it still doesn't allow for use of the up arrow to retrieve history, and is very quirky with how it handles editing of code. Their Oracle Forms product is very klunky, too. I'm happy I don't need to set up Web Logic servers, because that looks like a nightmare, too.
A little work on tooling would go a long way.
I am partial to using joins in where clauses instead of ansi sql join statements, so I guess there's that.