Oracle Database 10g: The Complete Reference (Paperback)

Kevin Loney

  • 出版商: McGraw-Hill Education
  • 出版日期: 2004-09-01
  • 定價: $2,370
  • 售價: 5.0$1,185
  • 語言: 英文
  • 頁數: 1369
  • 裝訂: Paperback
  • ISBN: 0072253517
  • ISBN-13: 9780072253511
  • 相關分類: Oracle資料庫
  • 立即出貨(限量) (庫存=1)

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

商品描述

Description:

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

商品描述(中文翻譯)

描述:
從Oracle Press出版的最全面的Oracle資料庫參考書中,深入了解Oracle Database 10g。從關鍵的架構概念到高級的面向對象概念,這本書包含近50個章節,旨在為您提供啟發。從早期版本升級,使用SQL、SQL Plus和PL/SQL。獲取代碼示例並訪問常用的文檔PDF,還包括附帶的CD-ROM上的完整電子書。超越基礎知識,學習安全性、文本搜索、外部表、在Oracle中使用Java等更多內容。

目錄:
第一部分:關鍵資料庫概念
第1章:Oracle Database 10g架構選項
第2章:安裝Oracle Database 10g並創建資料庫
第3章:升級到Oracle Database 10g
第4章:規劃Oracle應用程序-方法、風險和標準

第二部分:SQL和SQL*Plus
第5章:SQL中的基本詞彙
第6章:基本的SQL*Plus報告和命令
第7章:獲取文本信息並對其進行更改
第8章:搜索正則表達式
第9章:處理數字
第10章:日期:過去、現在和差異
第11章:轉換和轉換函數
第12章:將事物分組在一起
第13章:當一個查詢依賴於另一個查詢
第14章:一些複雜的可能性
第15章:Ch