Shop now Learn more Shop now Shop All Amazon Fashion Shop Suki Ad Campaign Pieces Cloud Drive Photos Shop now Amazon Fire TV Shop now Halloween Pets Shop now Shop Fire Shop Kindle Voyage Listen in Prime Learn more Shop now

Deliver to your Kindle or other device


Try it free

Sample the beginning of this book for free

Deliver to your Kindle or other device

Sorry, this item is not available in
Image not available for
Image not available

Oracle Database 12c The Complete Reference: The Complete Reference (Oracle Press) [Kindle Edition]

Bob Bryla , Kevin Loney
4.0 out of 5 stars  See all reviews (2 customer reviews)

Print List Price: £54.99
Kindle Price: £41.02 includes VAT* & free wireless delivery via Amazon Whispernet
You Save: £13.97 (25%)
* Unlike print books, digital books are subject to VAT.

Free Kindle Reading App Anybody can read Kindle books—even without a Kindle device—with the FREE Kindle app for smartphones, tablets and computers.

To get the free app, enter your e-mail address or mobile phone number.


Amazon Price New from Used from
Kindle Edition £41.02  
Hardcover £54.99  
Kindle Daily Deal
Kindle Daily Deal: Up to 70% off
Each day we unveil a new book deal at a specially discounted price--for that day only. Learn more about the Kindle Daily Deal or sign up for the Kindle Daily Deal Newsletter to receive free e-mail notifications about each day's deal.

Book Description

Master the Cutting-Edge Features of Oracle Database 12c

Maintain a scalable, highly available enterprise platform and reduce complexity by leveraging the powerful new tools and cloud enhancements of Oracle Database 12c. This authoritative Oracle Press guide offers complete coverage of installation, configuration, tuning, and administration. Find out how to build and populate Oracle databases, perform effective queries, design applications, and secure your enterprise data. Oracle Database 12c: The Complete Reference also contains a comprehensive appendix covering commands, keywords, features, and functions.

  • Set up Oracle Database 12c or upgrade from an earlier version
  • Design Oracle databases and plan for application implementation
  • Construct SQL and SQL*Plus statements and execute powerful queries
  • Secure data with roles, privileges, virtualization, and encryption
  • Move data with SQL*Loader and Oracle Data Pump
  • Restore databases using flashback and the Oracle Database Automatic Undo Management feature
  • Build and deploy PL/SQL triggers, procedures, and packages
  • Work with Oracle pluggable and container databases
  • Develop database applications using Java, JDBC, and XML
  • Optimize performance with Oracle Real Application Clusters

Customers Who Bought This Item Also Bought

Page of Start over
This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Product Description

About the Author

Bob Bryla has more than 20 years of experience in MIS, ranging from database and data warehouse design to system administration on multiple hardware platforms. He is currently lead designer and data analyst for Land’s End's online store database and handles the DBA activities on Land’s End Oracle Internet databases.

Kevin Loney was named Consultant of the Year by Oracle Magazine in 2002. He is an internationally recognized expert in the design, development, and administration and tuning of Oracle databases. An Oracle developer and database administrator since 1987, Loney has designed and implemented both transactional processing systems and data warehouses.

Product details

  • Format: Kindle Edition
  • File Size: 215669 KB
  • Print Length: 1472 pages
  • Publisher: McGraw-Hill Education; 1 edition (5 Aug. 2013)
  • Sold by: Amazon Media EU S.à r.l.
  • Language: English
  • Text-to-Speech: Enabled
  • X-Ray:
  • Word Wise: Not Enabled
  • Enhanced Typesetting: Enabled
  • Average Customer Review: 4.0 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Bestsellers Rank: #498,442 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
  •  Would you like to give feedback on images?

More About the Author

Discover books, learn about writers, and more.

What Other Items Do Customers Buy After Viewing This Item?

Customer Reviews

5 star
3 star
2 star
1 star
4.0 out of 5 stars
4.0 out of 5 stars
Most Helpful Customer Reviews
2 of 2 people found the following review helpful
By Tariq
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 | 
Was this review helpful to you?
2 of 3 people found the following review helpful
4.0 out of 5 stars Excellent reference book for your DBA bookshelf. 20 Mar. 2014
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 | 
Was this review helpful to you?
Most Helpful Customer Reviews on (beta) 4.1 out of 5 stars  14 reviews
7 of 7 people found the following review helpful
5.0 out of 5 stars Simple, precise and easy to understand 25 Nov. 2013
By Murali - Published on
This book is written in very simple, precise, straight forward and easy to understand language. There are tons of day to day usage SQLs and examples for everyday dba. Good amount of details in advanced topics like external tables, flashback, SQL replay, advanced security etc., Very useful Hitchhiker's guides and also a cd with code and ebook included. Over all the content is nicely presented.
6 of 7 people found the following review helpful
4.0 out of 5 stars This is a very important addition to the library of EVERY Oracle professional 30 Dec. 2013
By Earl D. Shaffer - Published on
Format:Kindle Edition
I just finished reading through "Oracle Database 12c - The Complete Reference". If you have been using Oracle for a while you are familiar with the title - Kevin and Bob have been publishing revised versions of the book for quite a while. And as the title says, this is not a tutorial or a how-to book. It is a reference book of many of the important topics that an Oracle professional will need to know in order to work effectively with 12c

The chapters cover the material you would think they would cover. Including the new CDB and PDB concepts in 12c. Also important newer - but not new - topics like VPD, TDE, SQL Replay. I was happy to find sections on Tuning but saw little on Data Guard and RMAN. As a DBA, I am not that interested in topics such as XML, Object-SQL, and Java. I would like to see the RAC section be larger. But overall, it is a very important addition to the library of EVERY Oracle professional. Keep the book at home, but keep the electronic copy of the book (on an include CD) with you everywhere.
3 of 3 people found the following review helpful
5.0 out of 5 stars A must have for DBAs that need a quick reference! 12 Feb. 2014
By Keith Bingham - Published on
Overall a solid book. Kevin has done a great job keep up with the changes between versions and has solid references through out the book. If you want clean oracle documentation this is the place... is not bad either, but the docs are 10x more voluminous - perhaps Larry would give the the :).
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
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.

2.0 out of 5 stars Missing details about Oracle 12c's Pluggable Database architecture 10 Aug. 2015
By Amazon Customer - Published on
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.
Were these reviews helpful?   Let us know
Search Customer Reviews

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
First post:
Prompts for sign-in

Search Customer Discussions
Search all Amazon discussions

Look for similar items by category