Oracle was the first DB I did major work with (12 yrs ago). I have fond memories of that time. I created an automated warehouse management system with it
Pros:
- pl/sql (I like it more than other flavors of sql, maybe because it was the first one I used a lot)
-pl sql developer. Not the java one (sql developer). I loved that you could see tabs in a list and in general it was smooth. I still keep a thin client in my spare drive and use it with delight from time to time
Cons:
-Installing and maintaining Oracle. But it wasn't terrible either
-Having to read Burleston posts. Not sure if this has improved
I know I am biased by my experience, I've heard many horror stories. I wouldn't choose Oracle today, but having to develop for it wouldn't scare me either
> pl/sql (I like it more than other flavors of sql, maybe because it was the first one I used a lot)
pl/sql is not a flavor of SQL, it is a name for the separate SQL-based “procedural” (imperative) language (hence the “pl”) supported by Oracle. The Oracle SQL dialect is usually referred to as “Oracle SQL” if there is a need to distinguish it.
Pros:
- pl/sql (I like it more than other flavors of sql, maybe because it was the first one I used a lot)
-pl sql developer. Not the java one (sql developer). I loved that you could see tabs in a list and in general it was smooth. I still keep a thin client in my spare drive and use it with delight from time to time
Cons:
-Installing and maintaining Oracle. But it wasn't terrible either
-Having to read Burleston posts. Not sure if this has improved
I know I am biased by my experience, I've heard many horror stories. I wouldn't choose Oracle today, but having to develop for it wouldn't scare me either