Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

Oracle Database 12c The Complete Reference (Oracle Press) by Bryla, Bob Published by McGraw-Hill Osborne Media 1st (first) edition (2013) Hardcover Hardcover

3.3 out of 5 stars 4 customer reviews

See all formats and editions Hide other formats and editions
Amazon Price
New from Used from
"Please retry"
£48.67 £54.03

Man Booker International Prize 2017
A Horse Walks Into a Bar has won the Man Booker International Prize 2017. Learn more
click to open popover

Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone

To get the free app, enter your mobile phone number.

Product details

  • Hardcover
  • ASIN: B00HQ1K9DO
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (4 customer reviews)
  • If you are a seller for this product, would you like to suggest updates through seller support?

Customer Reviews

3.3 out of 5 stars
5 star
4 star
3 star
2 star
1 star
See all 4 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Hardcover
Another quality book from Oracle Press; if you’re new into Oracle databases then this book has everything you need to get started. All the topics are well organised and structured. Really good introduction into database design which I was surprised to see. As well as the basic database fundamentals it covers more advanced topics such as virtual private databases, materialized views, plsql to mention a few. There were some 12c features notably the pluggable database but did feel it was an expansion of the 11g book with little bits of 12c nuggets.

If you’re an experienced dba then you will know most of the content in this book and if you’re looking for 12c content I would try the Oracle 12c New features book; if you are new to Oracle or have SQL Server background moving into Oracle, then this is a perfect title to keep as a reference.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Hardcover
The first book I bought as a wannabe Oracle DBA was Oracle The Complete Reference by Koch and Loney. (The second book was Oracle 7 DBA by Kevin Loney). It had 1100 pages and I read it from cover to cover. It was a great introduction to Oracle with quite a large emphasis on design and SQL and I felt I had a complete introduction.

Oracle 12c has expanded to 1500 pages and I obtained a copy hoping to learn more about 12c New Features and Recovery Manager and Dataguard in particular. However – silly me - they are big enough subjects in themselves and there are only short summaries in the book, referring to books devoted to just that subject. As others have noted, Oracle documentation is now so huge that NO book can be The Complete Reference. So this book by Bryla and Loney can really be no more (and no less) than a complete introduction with pointers elsewhere. As such it succeeds, though as a summary has too much detail about dynamic tables rather than just highlighting the key ones, whereas I’d have like more DBA commands. It consistently felt like a book written for an Oracle developer.

I particularly liked the roadmaps, highlighting useful new 12c features and what I skimmed was as cogent as ever. I had hoped to read it cover to cover, but it is just too big. So I’m left wondering if a shorter book is needed for wannabe DBAs or developers, but then you couldn’t call it The Complete Reference – but then it isn’t anyway. Though I suppose you could argue it’s the complete reference as it refers to other books 

The main gotcha for new DBAs or Developers who are thinking about trying new features (or any features) is LICENSING. So beware of any licence features that are enabled by default or have a mild reference to licensing, even if you use just once.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Hardcover
First off this is a big book nearly 1500 pages covering all aspects of the Oracle database. The book is split into 8 parts, starting sensibly with an introduction to database concepts and then we are into part 2 - SQL and SQL*Plus an indepth look at SQL in the 12c database. Part 3 was titled beyond the basics, although I wouldn't have put all the the subjects (SQL Loader, accessing remote data for example) in this section as I consider them to be amongst the basics too but the other areas such as VPD, TDE adn Oracle Text are an advanced topic which we explained well in this section.
Part 4, 5 and 6 covered using PL/SQL, Object-Relational Databases and Java in the Oracle Database respectively. Part 7 was described as a series of hitchhikers guides in to a number of areas, one example was the 12c specific Pluggable databases guide which took you through installing and managing PDBs on a 12c installation. Part is a very useful alphabetical reference of virtually all the commands you are likely to want to use in SQL, SQL*PLUS and PL/SQL. Each command is decribed and cross-referenced back into the main text of the book and within the alphabetical reference itself.
All in all it is a very useful reference and the inclusion of the CD an ebook version means you can leave the heavy book at home but still take the content with you where ever you need it.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Hardcover
Like everything to do with Oracle, this book is far from complete and is of very little value. It does not even contain a list of the error codes. If you are using Oracle, you will end up with plenty of them. The language used in this book is just daft - SQL is not 'speech'. A chapter entitled ' The basic parts of speech in SQL' is in reality nothing of the sort. It has nothing whatsoever to do with speech but appears to be a crash course in SQL. Something as fundamental as connecting to an Oracle database is given half a page and if it doesn't work, (which it almost certainly will not as printed in the book) the best advice on offer is to 'contact your company's database administrator' which illustrates very well the abundant arrogance that Oracle has towards it's customers. This book falls over at the first hurdle - it does not even provide sufficient information to connect to a database. If the book had assumed technical competence in Oracle, I would not expect to see such basic details such as how to connect but since it seems to feel it necessary to explain what SQL is (and dumb it down by calling it speech) it is clear that this book does not assume technical proficiency in Oracle products.
There is no doubt that Oracle as a database system had it's day many, many, many years ago. There is no reason these days to use this awful product (and it's expensive and awful documentation) as regardless of the platform being used there are better alternatives.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Helpful Customer Reviews on Amazon.com (beta) (May include reviews from Early Reviewer Rewards Program)

Amazon.com: 4.2 out of 5 stars 18 reviews
3 of 3 people found the following review helpful
2.0 out of 5 stars Missing details about Oracle 12c's Pluggable Database architecture 10 Aug. 2015
By Amazon Customer - Published on Amazon.com
Format: Hardcover Verified Purchase
In my opinion this book is missing details about Oracle 12c's Pluggable Database architecture. I expected specific content about both EM Express and Single/Multitenant configurations due to the subtitle of the book "Administer and Secure a Robust Cloud Based Environment". Although the old database architecture is still available for use, Oracle recommends new 12c databases utilize the single or multitenant pluggable database configuration. There are some screenshots of a CDB/PDB installation, (6 pages on Pluggable Databases in total) but other than that there are very few pages which detail administration tasks and specific architecture information within a "Cloud database" single tenant/ multitenant configuration in 12c. On the other hand, the book does holds good content as a quick reference guide and overview on many different aspects of Oracle databases. Perhaps for new DBAs, this book would be a welcome asset for those who like a quick dictionary type look up of any and all things Oracle on their bookshelf. However, for a more seasoned DBA it doesn't contain the depth I expected strictly based on the titile and subtitile.
2 of 2 people found the following review helpful
5.0 out of 5 stars Perfect as a reference and as a learning tool 11 May 2014
By Alexander Búfalo - Published on Amazon.com
Format: Hardcover Verified Purchase
This book is very good. I bought the hardcover volume and I am very glad with it. However, I am a little bit surprise with its content and need to explain:

1 - This book does not contain recipes for database administrators.
Although it contains many chapters explaining architecture and features, such as how to deploy ASM, Data Guard, etc. It cannot be used by a DBA to learn how to do day to day administration. If that is your goal, I recommend searching another book, like Oracle Press' Install and Administrate Oracle 12c.

2- It is perfect as a reference, but the text is not boring and anyone willing to know about a new concept will be very satisfied with this book. The appendix contains a complete commands reference in alphabetical order like ORACLE OTN guides (SQL REFERENCE AND PL/SQL REFERENCE), full of examples and text explaining them.

3- The textual part is very creative. In it one can find real classess on each topics. The language is simple and enthusiastic. The examples are simple to follow and well commented and the name of the chapters are amazing. For example, instead of saying "Chapter 12 - Grouping functions", they decided to name it "Chapter 12 - Grouping things together", instead of Subqeueries, "When one query depends on another" and so forth.

In final words, as a DBA, this book is an excellent reference and will allow me to learn new concepts. As a Developer, this book is perfect and gives real classes in SQL and PL/SQL as well as a very important chapter on how to use SQL PLUS properly.

P.S. I don't know if the kindle edition will be helpful since this book is REALLY BIG and heavy so kindle edition may be too small for a good reading.

1 of 1 people found the following review helpful
3.0 out of 5 stars Offline Version; Free Online Documentation. 10 July 2015
By SlipperySnail - Published on Amazon.com
Format: Hardcover Verified Purchase
This is the offline copy of the Oracle Database 12C. If per chance you do not have internet but you still would like to learn about Oracle 12C SQL, you can use this to your advantage. If however you want to use the Free Online Version, Here's the link to the Oracle 12C Documentation. [...]
5.0 out of 5 stars This book is really very good for those who wants to get knowledge in basic ... 3 Dec. 2016
By Amazon Customer - Published on Amazon.com
Format: Hardcover Verified Purchase
This book is really very good for those who wants to get knowledge in basic and advance level both. It satisfied my need. Further, I recommend this book to others as well.
5.0 out of 5 stars Five Stars 6 Feb. 2017
By Paulo Alberto - Published on Amazon.com
Format: Hardcover Verified Purchase
A complete publication about Oracle 12c
Were these reviews helpful? Let us know

Look for similar items by category