Oracle9i: The Complete Reference (Paperback)

Kevin Loney, George Koch

  • 出版商: McGraw-Hill Education
  • 出版日期: 2002-08-16
  • 定價: $2,250
  • 售價: 4.4$999
  • 語言: 英文
  • 頁數: 1256
  • 裝訂: Paperback
  • ISBN: 0072225211
  • ISBN-13: 9780072225211
  • 相關分類: Oracle

立即出貨(限量) (庫存=2)

買這商品的人也買了...

商品描述

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.


           

   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