Oracle Database 10g The Complete Reference

  • Authors:
  • Kevin Loney;Lisa McClain

  • Affiliations:
  • -;-

  • Venue:
  • Oracle Database 10g The Complete Reference
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

Abstract

Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.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