+612 9045 4394
Oracle Database 12c the Complete Reference (Set) : Oracle Press - Bob Bryla

Oracle Database 12c the Complete Reference (Set)

Oracle Press

Hardcover Published: 11th September 2013
ISBN: 9780071801751
Number Of Pages: 1472

Share This Book:


RRP $122.95
In Stock
if ordered within
Enter an Australian post code for delivery estimate

Earn 129 Qantas Points
on this Book

An all-new edition of the bestselling Oracle Press book ever published, fully revised and updated for the latest database release

  • Provides thorough coverage of all the changes'major and minor'that have taken place in the four years since the last release, including cloud integration
  • Previous editions sold nearly 400,000 copies
  • New chapters cover export and import, analytic functions, Object PL/SQL, new tuning features, new security measures, and more
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.

Wonderful book


This book is the perfect reference for people new to Oracle and seasoned users. It is very well written with excellent examples and humour to make a quite dry topic very interesting.




5.0 1


Part I: Critical Database Concepts 1. Oracle Database 11g Architecture Options 2. Installing Oracle Database 11g and Creating a Database 3. Upgrading to Oracle Database 11g 4. Planning Oracle Applications--Approaches, Risks, and Standards

Part II: SQL and SQL Plus 5. The Basic Parts of Speech in SQL 6. Basic SQL Plus Reports and Commands 7. Getting Text Information and Changing It 8. Searching for Regular Expressions 9. Playing the Numbers 10. Dates: Then, Now, and the Difference 11. Conversion and Transformation Functions 12. Grouping Things Together 13. When One Query Depends Upon Another 14. Some Complex Possibilities 15. Changing Data: Insert, Update, Merge, and Delete 16. DECODE and CASE: If, Then, and Else in SQL 17. Creating and Managing Tables, Views, Indexes, Clusters, and Sequences 18. Editioning 19. Basic Oracle Security

Part III: Beyond the Basics 20. Advanced Security--Virtual Private Databases 21. Advanced Security--On-Disk Encryption and Secure Backup 22. Working with Tablespaces 23. Using SQL Loader to Load Data 24. Using Data Pump Export and Import 25. Accessing Remote Data 26. Using Materialized Views 27. Using Oracle Text for Text Searches 28. Using External Tables 29. Using Flashback Queries 30. Flashback--Tables and Databases 31. Change, Replay, and SQL Replay

Part IV: PL/SQL 32. An Introduction to PL/SQL 33. Online Application Upgrades 34. Triggers 35. Procedures, Functions, and Packages 36. Using Native Dynamic SQL and DBMS_SQL 37. PL/SQL Tuning

Part V: Object-Relational Databases 38. Implementing Object Types, Object Views, and Methods 39. Collectors 40. Using Large Objects 41. Advanced Object-Oriented Concepts

Part VI: Java in Oracle 42. An Introduction to Java 43. JDBC Programming 44. Java Stored Procedures

Part VII: Hitchhiker's Guides 45. The Hitchhiker's Guide to the Oracle Data Dictionary 46. The Hitchhiker's Guide to Tuning Applications and SQL 47. Client-side query cache--use, configuration, and benefits 48. Case Studies in Tuning 49. Advanced Architecture Options--Records database, Vault, and Content Database 50. Oracle Real Application Clusters, Grid Architecture, and Management 51. The Hitchhiker's Guide to Database Administration 52. The Hitchhiker's Guide to XML in Oracle

ISBN: 9780071801751
ISBN-10: 0071801758
Series: Oracle Press
Audience: Professional
Format: Hardcover
Language: English
Number Of Pages: 1472
Published: 11th September 2013
Publisher: McGraw-Hill Education - Europe
Country of Publication: US
Dimensions (cm): 24.0 x 19.0  x 5.0
Weight (kg): 2.29
Edition Number: 1

Earn 129 Qantas Points
on this Book