4 ms·
Oracle has tons of "features" that postgres lacks: * empty string == NULL in oracle * ROWNUM: it's kinda like a limit, but not * DUAL: hah. postgres eat your
by quizotic 11y ago
Oracle has tons of "features" that postgres lacks:
* empty string == NULL in oracle
* ROWNUM: it's kinda like a limit, but not
* DUAL: hah. postgres eat your heart out.
And of course there are business practice differences:
http://www.businessinsider.com.au/oracle-customer-explains-audit-threats-2015-9 http://www.businessinsider.com.au/oracle-customer-explains-a...
... but tongue out of cheek, if you can afford it, Oracle has solutions for just about every database problem in just about every vertical domain. They have really good engineers, really good testing, and they're #1 for a reason
- je42 11y agoAnother one. DDL changes are not transactional.
- CaptainZapp 11y ago* empty string == NULL in oracle Why would that be a feature? NULL, by definition is neither 0 [zero], nor an empty string. NULL is an undefined value (sort of like a division by 0) Personally I'd see this as a bug, not as a feature. But your mileage may vary.
- jerven 11y agoYou missed the sarcasm quotes around the "feature" in the grandparent post.
- ldrndll 11y agoI think all those "features" are considered misfeatures by parent, and that he was being sarcastic.
- bsg75 11y agoUgh: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5984520277372 https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUE... I am not sure if I am more or less confused. +1 for PostgreSQL on this one.
- lobster_johnson 11y agoPostgres has row numbers: select *, row_number() over (order by id desc) as rownum from stuff; Window functions are really convenient. I'm not familiar enough with Oracle to say what the practical differences are, though.
- je42 11y agoThe commandline client: sqlplus is very convenient. It doesn't even have history. But you can fix it with rlwrap.