I applied through college or university. I interviewed at Oracle (Redwood City, CA) in Nov 2009
Interview
Interview with Oracle through college recruiting 4 years ago. If you graduate from their list of target school, it is easy to get an onsite. Before the onsite, the recruiter sent you a list of groups that are interested in interviewing you. You can pick 6-7 to interview with. It a whole day process. Each team you usually talk to their hire manager and one developer. Not much technical questions with the manager. The developer would ask some technical questions.
Directly invited by HR via email and scheduled an on-site three weeks later. The whole interview process works fine and as a potential employee, you would have more than enough opportunities to receive an offer from the company. I think they maintain a relatively strict invitation bar to limit school from which the candidate would graduate.
The campus hiring process for Oracle Apps was divided into two stages:
i) Online Exam
ii) Interview Round ( 2 tech, 2 HR )
Online exam had 4 sections: basic aptitude, basic programming (included topics on DBMS, DSA, OS), data interpretation and advanced programming (based on OOPS)
Tech interviews were based on basics of programming, OOPS, databases, algorithms and operating systems. There was nothing too hard about them if one knew ones concepts well.