There are a ton of Oracle interview questions posted on the web. Google "Oracle Interview Questions" and you will find plenty.

Adding my 2 cents ... I recently had an interview with a major IT company, it was a 7 person loop. One HR Person, one employee who took me to lunch and 5 more traditional 1 on 1 type interviews. Of the 5 traditional interviews, 4 asked me skillset type questions for which I was well prepared. The 5th person, however, asked me behavioral types of questions which I wasn't really prepared for ..."Tell me when was the last time you helped a customer ... Tell me how you helped get a team member promoted ... Tell me about a time when someone blamed you for something out of your control ..." So my advice to you is to study the "oracle questions" but also review behavioral questions.

Best of luck!