Problems with Oracle SQL

#1

Post by thunderbong » Fri, Sep 10, 2021, 3:55 PM UTC

Problems with Oracle SQL
codingtofreedom.com

Re: Problems with Oracle SQL

#2

Post by woodgrainz » Fri, Sep 10, 2021, 4:27 PM UTC

Drop the 'SQL', it's cleaner.

Re: Problems with Oracle SQL

#3

Post by mypastself » Fri, Sep 10, 2021, 4:29 PM UTC

Oh man, the infamous “Missing Right Parenthesis”. Many an hour has been spent trying to decipher Oracle’s passive-aggressive - and even actively misinformative - error messages.

Re: Problems with Oracle SQL

#4

Post by kunagi7 » Fri, Sep 10, 2021, 4:29 PM UTC

Well, 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

Re: Problems with Oracle SQL

#5

Post by recursivedoubts » Fri, Sep 10, 2021, 4:30 PM UTC

Looks like it might be getting hugged, here's an archive if you can't load it:

https://archive.is/MS2lJ

Re: Problems with Oracle SQL

#6

Post by qsort » Fri, Sep 10, 2021, 4:32 PM UTC

kunagi7 wrote: post #4

Well, 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

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.

Re: Problems with Oracle SQL

#7

Post by encryptluks2 » Fri, Sep 10, 2021, 4:33 PM UTC

woodgrainz wrote: post #2

Drop the 'SQL', it's cleaner.

Came here to say the same

Re: Problems with Oracle SQL

#8

Post by munk-a » Fri, Sep 10, 2021, 4:36 PM UTC

I'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 I figure actually hiring Oracle DBAs would be a nightmare.

These two factors combine to make me absolutely baffled at how completely Oracle has seemed to dominate every market but the private one (i.e. government, especially defense and educational). Have I been missing something about ways to actually get real world experience with Oracle?

Re: Problems with Oracle SQL

#9

Post by the_Devil » Fri, Sep 10, 2021, 4:37 PM UTC

Rude!

Re: Problems with Oracle SQL

#10

Post by tomrod » Fri, Sep 10, 2021, 4:37 PM UTC

qsort wrote: post #6

kunagi7 wrote: post #4

Well, 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

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