Oracle's statement of direction for Application Development Tools is also something you should probably read for your paper
About packaged applications, I think it's not exactly what I want to show, because are little apps for a certain problematic. I want to talk about big projects. If possible, as I said, ERPs, CRMs, and so on.
Not that anyone wants my opinion, but that list that is on the Apex site is pretty bad. A rough estimate from scanning them is that 40-50% of them are from companies who either
1) Are Oracle or from people employed by Oracle
2) Are Oracle consulting companies
3) Are Apex-specific interests (blogs, consulting)
Not that it's not a valid representation of what you can build, but it's also highly prejudicial. In other words, I would expect someone trying to sell me Apex services to build their site on it. Oracle themselves have a few technologies, but they're going to build it on one of them.
If I were a customer, I'd want to see a customer who has no affiliation with Oracle and decided to choose Apex over other frameworks. Not to mention that some of those listed either stopped using Apex, or don't use it for customer facing sites.
The short of it is that it's still a niche product - Joel doesn't like me saying that, but it's true. So finding a long list of people who use it for internet applications are going to be much shorter than other technologies - it's just a fact. People generally don't sell a ton of commercial software that has a restriction of using only one specific database (even if it's if the unpatchable XE). They want options - that is why you aren't going to see a ton of commercial software made with Apex and sold by anyone other than Oracle.
+>> The short of it is that it's still a niche product - Joel doesn't like me saying that, but it's true.+
Actually, I don't mind you saying that at all. One could say that anything which is proprietary to Oracle is "niche" too. But the way I look at it - if we all we do is help the muti hundred-thousand Oracle database customers be productive and happy with their investment in the Oracle platform, then we've done our job. And if numerous Global Fortune 100 customers running hundreds (and some cases, thousands) of APEX applications is "niche", then we welcome the "niche" label at any time. ;)
I agree, by the way...that external customer list is dated and biased. I'd prefer it if none were developed by Oracle or any Oracle partners. We'll work to improve the list.