My favourite oracle issue was an older version would not install on Linux if you had number lock key on!
Problems with Oracle SQL
51–60 of 277 posts
Re: Problems with Oracle SQL
#52It seems to be the general rule of thumb that, when you want to google for an oracle error message, then exclusion of both oracle documentation site, and developer forums is your first criteria on the search bar. Same applies to Microsoft (large parts of MSDN), and now Amazon Web Services documentation (at least some parts of it). That's the reason StackOverflow works - it really solves programmer's problems, instead…
The aws docs aren’t concise, but they have a lot of good information in them if you want to go in depth. I learned a lot back when I was an intern by reading them
Iirc, the postgres docs were also good reading in a similar way: not concise, but a lot of good information
Re: Problems with Oracle SQL
#53Anecdotal, but wanted to mention positive experience with Oracle support.
I have posted questions on SO relating to Oracle SQL and SqlDeveloper, and Oracle staff responded quickly with a solution I accepted.
Shoutout to ThatJeffSmith for contributing to the community!
Re: Problems with Oracle SQL
#54We need simple 2 line explainers with 10 lines of explainer codes. Show the codes enough fluff and padding.
Give the juice.
A wall of text with options and no actual code example that you can try isn't going to help so much.
Options and parameters everywhere.
Re: Problems with Oracle SQL
#55I've worked with databases for a while now and I've never advocated for moving to Oracle (I have advocated for postgres though). The long term organizational costs is a big factor - but an almost equally large factor is the fact that 1. I have never actually used their dialect and have heard absolutely terrible things about it 2. There is no non-enterprise DBMS available that uses something close to their dialect so…
Back in the day MS SQL was Windows-only and Postgres was not mature, so the choice was Oracle or DB2. And Oracle was more popular, because it used more progressive model (versions vs DB2 locks). Plenty of people who don't closely follow recent trends associate database with Oracle, so when they have a word, they'll choose it. Oracle it not that bad anyway, it's just stupidly expensive. I'd choose Postgres any day, bu…
> so the choice was Oracle or DB2
Sybase, Ingres
Re: Problems with Oracle SQL
#56Well, I used to work with Oracle Databases and that "old man" (Donald Burleson) website has saved me quite a few times. I even remember the "Learn Oracle at the Sea" advertisement. But that's the state of affairs and I try to avoid them as much as I can. Amazon seems to think similar [0]. [0] https://www.youtube.com/watch?v=9yBP5gnnZi4
My goto was Tom Kyte (https://asktom.oracle.com) for learning the 'why'. Burleson is an interesting character, but not always correct either.
Re: Problems with Oracle SQL
#57Earlier quoted context omitted.
To be really fair, have you ever seen SQL error messages that don't suck? I do agree that Oracle's are the worst by far though.
I feel Postgres and SQL Server are easier to grok error states. Oracle seems to want to be an application platform more than a datastore
Exactly, Oracle should be chosen when business logic is written in sql/plsql
Re: Problems with Oracle SQL
#58Oracle SQL is not the devil.
I can code up SQL easily and find errors. I use sqldeveloper and granted It's not as helpful as say coding Dart on Android Studio IDE in pinpointing where a problem is and making suggestions. But I've been able maintain single sql statements 800 lines long, perform knapsack in a single sql statement, and develop complex packages in Oracle.
If you really want to see super complexity, download and create an Oracle EBS 12.2 virtualbox instance and checkout the PL/SQL packages in the APPS schema and the schemas themselves of which there are over 200.
I've used NoSQL and other SQL databases, each which had their challenges. I like the free tooling that Oracle provides - The APEX app builder and XE database are nice, if not hosted on Oracle Cloud - try the libvirt instance to evade Oracle's cloud grip.
I think the problem here is developer experience and a negative bias toward Oracle, which is understandable and prevalent in the developer community.
Cheers
Re: Problems with Oracle SQL
#59It seems to be the general rule of thumb that, when you want to google for an oracle error message, then exclusion of both oracle documentation site, and developer forums is your first criteria on the search bar. Same applies to Microsoft (large parts of MSDN), and now Amazon Web Services documentation (at least some parts of it). That's the reason StackOverflow works - it really solves programmer's problems, instead…
In my experience both Oracle and Microsoft documentation is usually good to excellent,I actually want google to search specifically on ms docs site most of the time. I do find AWS docs to be lengthy and incomprehensible.
StackOverflow is mostly useful to quickly (and often dirtly) solve issues that are burning now, without getting deeper understanding of the subject. This isn't universally true, some answers are exceptionally good.
Re: Problems with Oracle SQL
#60The biggest WTF for me is that you can't put parameters in `EXPLAIN` queries. This killed support for `Queryset.explain()` on Oracle in Django.
Seems like such a weird limitation, and the error messages definitely where not helpful.