Oracle Database 11g The Complete Reference (Osborne ORACLE Press Series)

The Definitive Guide to Oracle Database 11g

Get full details on the powerful features of Oracle Database 11g from this thoroughly updated Oracle Press guide. Oracle Database 11g: The Complete Reference explains how to use all the new features and tools, execute powerful SQL queries, construct PL/SQL and SQL*Plus statements, and work with large objects and object-relational databases. Learn how to implement the latest security measures, tune database performance, and deploy grid computing techniques. An invaluable cross-referenced appendix containing Oracle commands, keywords, features, and functions is also included.

Install Oracle Database 11g or upgrade from an earlier version
Create database tables, sequences, indexes, views, and user accounts
Construct SQL statements, procedures, queries, and subqueries
Optimize security using virtual private databases and transparent data encryption
Import and export data using SQL*Loader and Oracle Data Pump
Use SQL replay, change management, and result caching
Avoid human errors using flashback and automatic undo management
Build and tune PL/SQL triggers, functions, and packages
Develop database applications using Java, JDBC, and XML
Optimize availability and scalability with Oracle Real Application Clusters

Customer Reviews:

Expensive Paperweight

By Benjamin C Lewis - September 24, 2010

If you have no internet access, this book is better than nothing, but otherwise stick with the free online books and docs provided by Oracle. Indeed, the last 1/3 or so of this book is just reference material copied directly from Oracle's free docs, but is more difficult to navigate without the hyperlinked crossreferences.

The book is not "complete" as the title suggests, not covering all new features (case-insensitivity using NLS_SORT, NLS_COMP is just one example).

Additionally, not all the information is accurate -- the author does not even know what the term "relational database" means, he thinks "relations" have something to do with foreign keys. A common misconception yes, but worrisome from a database "expert". I also found incorrect syntax in the transportable tablespace section, before I gave up with the book entirely.

Use at your own risk, and consider that the author has given his own book a 5 star rating on this site!

Oracle complete reference

By Richard John - November 13, 2009

Generally the book is well written , but the approach is for very highly technical individuals. Since I am primary a SQL programmer, about half the book is not what I need. However, I use this book on PL/SQL more than I use the book "Oracle PL/SQL Programming". I found this book is better organized to check syntax on various functions. My DBA is usually checking the book for her job and she has found the book to be helpful for her needs. Overall I would recommend the book as a group reference.

Great reference

By Will - November 17, 2009

I have been using this book or one of its earlier versions for six years. It does a great job of filling in the blanks for people like me who learned Oracle in the monkey-see monkey-do fashion of on the job training. It continues to be a great reference because it has a great index -- probably the best index in any technical book I own. I can find a term in the index very quickly and then flip to a focused explanation of that term. This usually much faster than flailing around the web doing word searches for the same information. It is an expensive book, but I have saved in frustration what I spent in dollars. It is very difficult to keep it on my desk because it is borrowed so often.