There are 2 types of technologies: the ones that people complain about and the ones that nobody uses.
No. Some technologies are hostile to the people forced to use them.
Problems with Oracle SQL
61–70 of 277 posts
Re: Problems with Oracle SQL
#62It 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…
I’m currently taking my first foray into the world of MS applications for work. Have to write something that interacts with an EWS server and I’ve been… overwhelmed with not only the disorganization of their docs, but also the super strong push to do everything in C# instead of just telling me which SOAP (yes that soap) parameters/documents to use for certain actions. If anyone here wants to defend MS and tell me I’m horribly wrong and point me to some fantastic docs somewhere I would be so delighted to be proven wrong.
Re: Problems with Oracle SQL
#63It 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…
I'm not sure why the hate against MSDN - at least for .NET, I found the documentation to be one of the best in the business -even a decade ago. I'd only put Go's docs ahead in terms of helpfulness. I cut my teeth writing .NET code, then switched to Java writing apps on Android - the step down in doc quality was quite significant.
Re: Problems with Oracle SQL
#64The title should rather be: „Oracle Is the Devil“.
Re: Problems with Oracle SQL
#65Earlier quoted context omitted.
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
Potato Patahto
Re: Problems with Oracle SQL
#66It 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 exce…
Somewhat unrelated, the case where I want to "Google search some specific site" is well suited to duckduckgo bangs, if there is a bang for that site.
!msdn will search MS's developer network
Re: Problems with Oracle SQL
#67Beside the regular complaints or praises I find oracle extremely ugly, unaesthetic and inconsistent. I understand it is old and has backwards compatibility but why would anyone choose oracle over a newer modern RBDMS such as PostgreSQL or MSSQL for a new project? Besides, Oracle is very expensive and very hard to get rid of.
It is also a bit of an issue that they don't have a default IDE, I worked with Rapid SQL which is a clunky, slow and riddled with bugs IDE. I think the Rapid part of its name is pure gaslighting.
Re: Problems with Oracle SQL
#68fun fact: if youve ever wondered why performance benchmarks dont really seem to exist between things like mysql or postgres and Oracle, its because this is expressly forbidden in your license.
Re: Problems with Oracle SQL
#69This is missing my favorite oracle quirk: Empty strings are equivalent to null. Trying to insert an empty string into a NOT NULL column will fail, which took me a while to understand the first time I saw it happen.
So how do you insert an empty string into a NOT NULL column? Please don't tell me that it's not possible.
Honestly that's bad db design anyways. If empty string is a valid value then you don't want NOT NULL anyways. This is a table structure constraint, not a variable declaration. NOT EMPTY would have been a better syntax imo but that's a whole can of worms.
Re: Problems with Oracle SQL
#70It 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…
I'm not sure why the hate against MSDN - at least for .NET, I found the documentation to be one of the best in the business -even a decade ago. I'd only put Go's docs ahead in terms of helpfulness. I cut my teeth writing .NET code, then switched to Java writing apps on Android - the step down in doc quality was quite significant.
MSDN isn't terrible, but for answers.microsoft.com 90% of questions are some outsourced foreign support rep telling the user to run sfc /scannow and not looking into the issue any further. Which makes it a huge pain for sysadmin type stuff, their developer documentation is much better.