Oracle Database 10g The Complete Reference
1st Edition
0072253517
·
9780072253511
© 2004 | Published: September 7, 2004
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Get a thorough understanding of Oracle Database 10g from th…
Read More
Request Review Copy
Receive via shipping:
- Print bound version of the complete text
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
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
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.
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.