These days, that line may be blurred a little bit, and you can see how both paradigms (and more!) can be combined into a single product with PostgreSQL, but I feel like the MacBook analogy really sums up the way I feel about these two systems.
I'm not a certified DBA so take this with a grain of salt, but it seems that any non-trivial use of Oracle systems ramp up in cost very quickly. Both in terms of hard cash and time in education/training.
Good point; I was considering mostly the situation where there isn't something already on hand, but it makes sense that there would be quite a lot of times where MySQL and Oracle DB are considered alternatives for a new project/application by shops who already have an existing installation of one or the other.
I don't think the MBPro/MBAir comparison is quite right. I think it's more like MBAir versus Mac Pro: it is very easy to see a single person having both of them and utilizing both of them extensively.
Does it really? I mean, sure, they are both RDBMS's, but that's a pretty broad market. Are there really that many use cases where, with the current market, people who are using MySQL would have Oracle as their next choice or vice versa?
I can see an argument that MySQL competes with some of the same products that Oracle DB competes with (but in different market segments than where Oracle DB does), but I don't see them as directly competitive in any significant sense.