Oracle Database 10g The Complete Reference [NOOK Book]

( 3 )

Overview

The Ultimate Resource on Oracle Database 10g



Get thorough coverage of Oracle Database 10g from the most comprehensive reference available, published by Oracle Press. With in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java ...

See more details below
Oracle Database 10g The Complete Reference

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$75.00
BN.com price

More About This Book

Overview

The Ultimate Resource on Oracle Database 10g



Get thorough coverage of Oracle Database 10g from the most comprehensive reference available, published by Oracle Press. With in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology, and covers SQL, SQL*Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java programming in the Oracle environment. You’ll also find valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics.





  • Install Oracle Database 10g or upgrade from an earlier version

  • Execute SQL queries

  • Perform complex searches easily with regular expression functions

  • Implement security measures using Virtual Private Databases (VPDs)

  • Move data with SQL*Loader and Data Pump

  • Replicate data and aggregations using materialized views

  • Execute flashback queries to recover data or see its changes over time

  • Create triggers, stored procedures, and packages with PL/SQL

  • Develop applications with JDBC and XML

  • Work with Oracle Database 10g Real Application Clusters (RAC) and grid technologies

  • Take advantage of the new tuning features



CD-ROM includes a searchable electronic book and all code examples from the book.



About the Author: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine’s Editors’ Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups.

Read More Show Less

Product Details

  • ISBN-13: 9780071770491
  • Publisher: McGraw-Hill Education
  • Publication date: 9/28/2004
  • Series: Oracle Press
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 1392
  • File size: 35 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine.
Read More Show Less

Table of Contents

PART I: Critical Database Concepts Chapter 1: Oracle Database 10g Architecture Options Chapter 2: Installing Oracle Database 10g and Creating a Database Chapter 3: Upgrading to Oracle Database 10g Chapter 4: Planning Oracle Applications—Approaches, Risks, and Standards PART II: SQL and SQL*Plus Chapter 5: The Basic Parts of Speech in SQL Chapter 6: Basic SQL*Plus Reports and Commands Chapter 7: Getting Text Information and Changing It Chapter 8: Searching for Regular Expressions Chapter 9: Playing the Numbers Chapter 10: Dates: Then, Now, and the Difference Chapter 11: Conversion and Transformation Functions Chapter 12: Grouping Things Together Chapter 13: When One Query Depends upon Another Chapter 14: Some Complex Possibilities Chapter 15: Changing Data insert, update, merge, and delete Chapter 16: DECODE and CASE: if, then, and else in SQL Chapter 17: Creating and Managing Tables, Views, Indexes, Clusters, and Sequences Chapter 18: Basic Oracle Security PART III: Beyond the Basics Chapter 19: Advanced Security—Virtual Private Databases Chapter 20: Working with Tablespaces Chapter 21: Using SQL*Loader to Load Data Chapter 22: Using Data Pump Export and Import Chapter 23: Accessing Remote Data Chapter 24: Using Materialized Views Chapter 25: Using Oracle Text for Text Searches Chapter 26: Using External Tables Chapter 27: Using Flashback Queries Chapter 28: Flashback—Tables and Databases PART IV: PL/SQL Chapter 29: An Introduction to PL/SQL Chapter 30: Triggers Chapter 31: Procedures, Functions, and Packages Chapter 32: Using Native Dynamic SQL and DBMS_SQL PART V: Object-Relational Databases Chapter 33: Implementing Types, Object Views, and Methods Chapter 34: Collectors (Nested Tables and Varying Arrays) Chapter 35: Using Large Objects Chapter 36: Advanced Object-Oriented Concepts PART VI: Java in Oracle Chapter 37: An Introduction to Java Chapter 38: JDBC Programming Chapter 39: Java Stored Procedures PART VII: Clustered Oracle—The Grid Chapter 40: Oracle Real Application Clusters Chapter 41: Grid Architecture and Management PART VIII: Hitchhiker’s Guides Chapter 42: The Hitchhiker’s Guide to the Oracle Data Dictionary Chapter 43: The Hitchhiker’s Guide to Tuning Applications and SQL Chapter 44: Case Studies in Tuning Chapter 45: The Hitchhiker’s Guide to Oracle Application Server 10g Chapter 46: The Hitchhiker’s Guide to Database Administration Chapter 47: The Hitchhiker’s Guide to XML in Oracle Appendix: Alphabetical Reference
Read More Show Less

Customer Reviews

Average Rating 2.5
( 3 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(2)

2 Star

(1)

1 Star

(0)
Sort by: Showing all of 3 Customer Reviews

  • Anonymous

    Posted Wed May 30 00:00:00 EDT 2007

    It is NOT a Complete Reference!

    For a book with 1350+ pages, I expected MUCH more content and simplified syntax. Instead, all of the content is vague with weak examples. Many topics are simply mentioned in a glossary-like listing at the end of the book, but have no supporting detail. The book does come with a CD containing a PDF of the entire book... well, not quite. They left out the INDEX!!! So, yes you can do a search for whatever you're looking for, but try something like 'variable' and you'll get a million hits before getting to the section you're looking for. Another thing, you CANNOT copy/paste from the PDF -- copyright protection disables that functionality in the PDF. I found that the FREE guides on Oracle's website are more informative and complete than this book -- and yes, they are FREE, come in PDF, and allow you to copy/paste out of them. Look elsewhere for a good reference -- this is not it.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  NoThank you for your feedback.   Report this reviewThank you, this review has been flagged.

  • Anonymous

    Posted Thu Oct 30 00:00:00 EDT 2008

    No text was provided for this review.

  • Anonymous

    Posted Mon May 31 00:00:00 EDT 2010

    No text was provided for this review.

Sort by: Showing all of 3 Customer Reviews
If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)