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.