Master SQL and PLSQL in the Oracle Database
Oracle Database 11g SQL is a newly updated version of the classic Oracle Press SQL book. This version has been updated for Oracle database 11g, but also covers all versions of Oracle from 8i, 9i, 10g to 11g.
Oracle Database 11g SQL is quite a big book, now with over 650 pages, so it should cover most aspects of SQL. The book includes 17 chapters with one appendix covering the Oracle data types.
The book does cover all aspects of SQL including whole chapters on Large Objects, Running SQL using Java, SQL tuning and using XML with Oracle.
If you are going to just be looking for new SQL that comes with 11g then I would probably recommend the Oracle Database 11g New Features book instead, as you may already know a lot of the areas of SQL that this book covers.
Oracle Database 11g SQL also includes a lot of DBA SQL areas such as creating tables, sequences, indexes, views, triggers as well as covering SQL tuning and creating and administering users, roles and privileges.
The book includes a great many examples and code to follow in order to make it easier to learn all the aspects of SQL, the publishers also offer you free code online.
Overall a great book which includes all the topics of SQL you will ever need to know about, until Oracle releases another new version of the database that is.