|
|
|
|
|
by collaborative
1746 days ago
|
|
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 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.