Oracle9i: The Complete Reference (Paperback)

The Renowned Oracle Resource--Fully Updated for Oracle9i

Get comprehensive information on all the features of Oracle9i. Written by best-selling authors and Oracle gurus Kevin Loney, George Koch, and the experts at TUSC, Oracle9i: The Complete Reference covers critical relational, object-relational, and Web database concepts, as well as SQL, SQL*PLUS, PL/SQL, Java, JDBC, SQLJ, and XML programming. Youll also get full details on database administration techniques--and much more. This authoritative volume is a must-have tool for all Oracle professionals.

• Use flashback queries to see data as it existed prior to commits
  
• Create, query, and manage external tables
  
• Create partitions, indexes, and tablespaces
  
• Execute and tune SQL queries
  
• Produce sophisticated reports using SQL*PLUS
  
• Load data from external files into Oracle database tables with SQL*Loader
  
• Create triggers, stored procedures, functions, and packages with PL/SQL
  
• Implement types, object views, and methods
  
• Develop robust database applications with SQLJ, JDBC, and XML
  
• Take advantage of the Oracle9i data dictionary and optimizer
  
• Tour the components of Oracle9i Application Server (Oracle9iAS)
  
• Manage, tune, back up, and recover Oracle9i databases
  
• Learn anytime, anywhere with a 90-day Oracle University Professional subscription. Details on CD-ROM
  

Bonus CD includes fully searchable electronic book, complete listings of all tables, and an Oracle9i Information & Documentation Kit featuring Release 2 New Features White Paper and selected documentation.

Contents           

   PART I: Critical Database Concepts
    1: Sharing Knowledge and Success
    2: The Dangers in a Relational Database
    3: The Basic Parts of Speech in SQL
    4: The Basics of Object-Relational Databases
    5: Introduction to Web-Enabled Databases

   PART II: SQL and SQL*PLUS
    6: Basic SQL*PLUS Reports and Commands
    7: Getting Text Information and Changing It
    8: Playing the Numbers
    9: Dates: Then, Now, and the Difference
    10: Conversion and Transformation Functions
    11: Grouping Things Together
    12: When One Query Depends upon Another
    13: Some Complex Possibilities
    14: Building a Report in SQL*PLUS
    15: Changing Data: insert, update, merge, and delete
    16: Advanced Use of Functions and Variables
    17: DECODE and CASE: if, then, and else in SQL
    18: Creating, Dropping, and Altering Tables and Views
    19: By What Authority?
    20: Changing the Oracle Surroundings
    21: Using SQL*Loader to Load Data
    22: Accessing Remote Data
    23: Using Materialized Views
    24: Using Oracle Text for Text Searches
    25: Using External Tables
    26: Using Flashback Queries

   PART III: PL/SQL
    27: An Introduction to PL/SQL
    28: Triggers
    29: Procedures, Functions, and Packages

   PART IV: Object-Relational Databases
    30: Implementing Types, Object Views, and Methods
    31: Collectors (Nested Tables and Varying Arrays)
    32: Using Large Objects
    33: Advanced Object-Oriented Concepts

   PART V: Java in Oracle
    34: An Introduction to Java
    35: JDBC and SQLJ Programming
    36: Java Stored Procedures

   PART VI: Hitchhiker’s Guides
    37: The Hitchhiker’s Guide to the Oracle9i Data Dictionary
    38: The Hitchhiker’s Guide to the Oracle Optimizer
    39: The Hitchhiker’s Guide to Oracle9iAS
    40: The Hitchhiker’s Guide to Database Administration
    41: The Hitchhiker’s Guide to XML in Oracle

   PART VII: Alphabetical Reference
Reference