Oracle at Facebook: http://venturebeat.com/2010/12/08/tim-campos-dreamforce-comm...
Correct me if I'm wrong, Amazon (the retail online store) was using Oracle in the past. I don't know what DB they're using now.
Ditto with eBay.
The other good reason is that Oracle hires some of the very best sales people in the world, and nobody is selling postgres, mySQL, etc to the same extent. There's a huge difference between being a 'technically better' product and being able to convince a PHB of that. Also, Oracle tends to support damn near everything, and damn near everything (Enterprisey) supports Oracle.
It's the 'safe' choice if you can afford it.
To mimic MySQL's "SELECT last_name FROM employees LIMIT 50,50" you have to do something like this:
SELECT last_name FROM (SELECT last_name, ROW_NUMBER() OVER (ORDER BY last_name) R FROM employees) WHERE R BETWEEN 51 and 100;
Aside from that, it's general operational differences and variations from the SQL spec on a pretty grand scale. The flip side to that though is that most serious Enterprise companies are generally using Oracle already anyway, so it's safe to target Oracle or MS-SQL and know that almost all of your customers will have one or both.
But then I find that companies with huge datasets like Amazon, Facebook, Twitter, etc... don't use it. And I go back to scratching my head.