Oracle9i: The Complete Reference (Paperback)

Kevin Loney, George Koch

  • 出版商: McGraw-Hill Education
  • 出版日期: 2002-08-16
  • 定價: $2,250
  • 售價: 5.0$1,125
  • 語言: 英文
  • 頁數: 1256
  • 裝訂: Paperback
  • ISBN: 0072225211
  • ISBN-13: 9780072225211
  • 相關分類: Oracle
  • 立即出貨(限量) (庫存=1)

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

商品描述

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

商品描述(中文翻譯)

著名的Oracle資源--全面更新至Oracle9i



由暢銷作家和Oracle專家Kevin Loney、George Koch以及TUSC的專家撰寫的Oracle9i: The Complete Reference提供了關於Oracle9i的所有功能的詳細信息。本書涵蓋了關鍵的關聯、物件關聯和Web數據庫概念,以及SQL、SQL*PLUS、PL/SQL、Java、JDBC、SQLJ和XML編程。您還將獲得有關數據庫管理技術的詳細信息,以及更多內容。這本權威性的專業書籍是所有Oracle專業人士必備的工具。






  • 使用回溯查詢查看提交之前的數據


  • 創建、查詢和管理外部表


  • 創建分區、索引和表空間


  • 執行和調優SQL查詢


  • 使用SQL*PLUS生成複雜的報表


  • 使用SQL*Loader將外部文件中的數據加載到Oracle數據庫表中


  • 使用PL/SQL創建觸發器、存儲過程、函數和包


  • 實現類型、對象視圖和方法


  • 使用SQLJ、JDBC和XML開發強大的數據庫應用程序


  • 充分利用Oracle9i數據字典和優化器


  • 深入了解Oracle9i應用程序服務器(Oracle9iAS)的組件


  • 管理、調優、備份和恢復Oracle9i數據庫


  • 通過90天的Oracle大學專業訂閱隨時隨地學習。詳情請參閱CD-ROM




附贈CD包括可全文搜索的電子書、所有表格的完整列表,以及一個包含Release 2新功能白皮書和選定文檔的Oracle9i信息和文檔套件。



目錄           

   第一部分:關鍵數據庫概念
    1:分享知識和成功
    2:關聯數據庫中的危險
    3:SQL的基本部分
    4:物件關聯數據庫的基礎知識
    5:Web啟用數據庫簡介

   第二部分:SQL和SQL*PLUS
    6:基本的SQL*PLUS報表和命令
    7:獲取文本信息並對其進行更改
    8:處理數字
    9:日期:過去、現在和差異
    10:轉換和轉換函數
    11:將事物分組在一起
    12:一個查詢依賴於另一個的情況
    13:一些複雜的可能性
    14:在SQL*PLUS中構建報表
    15:更改數據:插入、更新、合併和刪除
    16:函數和變量的高級使用
    17:在SQL中使用DECODE和CASE:if、then和else
    18:創建、刪除和修改表和視圖
    19:以何種權限?
    20:更改Oracle環境
    21:使用SQL*Loader加載數據
    22:訪問遠程數據
    23:使用物化視圖
    24:使用Oracle Text進行文本搜索
    25:使用外部表
    26:使用回溯查詢

   第三部分:PL/SQL
    27:PL/SQL簡介
    28:觸發器
    29:存儲過程、函數和包

   第四部分:物件關聯