Oracle SQL book?

[niebs2]

I was wondering what a good book to learn more advanced Oracle sql would be. I have a book i started to learn sql with years ago and now need to learn more since 11g has more features then i am aware of and need to learn.
Book i started with is: SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez and John L. Viescas
Book i found and think might be good: Oracle SQL By Example (4th Edition) by Alice Rischert

What do people think?

 

[johnherman]

A lot depends on what you're going to do with the SQL. Are you interested in using ANSI-SQL or Oracle extensions (PL/SQL). And also if you're interested in application programming, or DBA/Systems programming.
For ANSI, I like

http://www.amazon.com/Practical-SQL...366373821&sr=1-7&keywords=SQL+-server+-no+-my

For that book, there is also a Vol 2, but I think Vol 1 is the "better" buy.
For PL/SQL, the ones from Oracle Press and the ones from Feuerstein.



====================================
Sometimes the grass is greener on the other side because there is more manure there - original.

 

[niebs2]

Thanks John for the book recommendations. I usually work on Oracle dbs mostly. But i do like to know and they tend to be similar with each other. I will check them out and see what might be better overall. I do mostly QA/BA work.