This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
I've read the book Chris suggested; in fact I wrote that review. If I was only buying one book, I would go with a book that just covered Oracle. Mainly because I like to try to avoid Oracle specific features. If you plan on writing stored procedures or otherwise tying yourself into Oracle, that is the book to choose though.
I haven't read The Complete Reference, so I can't compare either book to that.