Oracle SQL*Plus : The Definitive Guide, 2/e (Paperback)

Jonathan Gennick

  • 出版商: O'Reilly
  • 出版日期: 2004-12-21
  • 定價: $1,300
  • 售價: 5.0$650
  • 語言: 英文
  • 頁數: 586
  • 裝訂: Paperback
  • ISBN: 0596007469
  • ISBN-13: 9780596007461
  • 相關分類: OracleSQL
  • 立即出貨(限量) (庫存=2)

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

商品描述

Description:

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.

The new second edition of Oracle SQL*Plus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform.

With Oracle SQL*Plus: The Definitive Guide, you'll expertly:

  • write and execute script files
  • generate ad hoc reports
  • extract data from the database
  • query the data dictionary tables
  • customize an SQL*Plus environment
  • and much more


It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.

This book is truly the definitive guide to SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.  

 

 

Table of Contents:

Introduction 
      Command-Line SQL*Plus 
                Starting SQL*Plus 
                Entering Commands 
                Strings in SQL*Plus Commands 
                Specifying Filenames 
                Naming Variables 
      Browser-Based SQL*Plus 
                Starting and Stopping iSQL*Plus 
                Connecting to iSQL*Plus 
                Connecting to a Database 
                Connecting as SYSDBA 
                Creating SYSDBA Users 
                Entering and Executing Commands 
                Getting Output as Plain Text 
                Executing Scripts 
                Disconnecting from iSQL*Plus 
      Selecting Data 
                The SELECT Statement 
                Nulls 
                CASE Expressions 
                Table Joins (Oracle8i and Earlier) 
                Table Joins (Oracle9i and Higher) 
                Partition Outer Joins 
                Summary Queries 
                Unions 
                Partition Operations 
                Flashback Queries 
      Modeling Data 
                MODEL Clause Syntax 
                MODEL Clause Functions 
                MODEL Clause Example 
      Inserting Data 
                Inserting One Row 
                Inserting the Results of a Query 
                Multitable Inserts (Oracle9i and Higher) 
      Updating Data 
                Simple Updates 
                Noncorrelated Subqueries in the SET Clause 
                Correlated Subqueries in the SET Clause 
      Deleting Data 
                Simple Deletes 
                Deleting All Rows (TRUNCATE) 
                Deleting Duplicate Rows 
      Merging Data (Oracle9i and Higher) 
      Transaction Management 
                SET TRANSACTION 
                SAVEPOINT 
                COMMIT 
                ROLLBACK 
      Formatting Text Reports 
                Column Headings 
                Column Formats 
                Page Width and Length 
                Page Headers and Footers 
                Page Breaks 
                Report Breaks 
      Formatting HTML Reports 
                The Concatenation Approach 
                Generating Full Pages 
      Tuning SQL 
                Creating the Plan Table 
                Explaining a Query 
                Using DBMS_XPLAN 
                Querying the Plan Table 
                Using Optimizer Hints 
      SQL*Plus Format Elements 
                Formatting Numbers 
                Formatting Character Strings 
                Formatting Dates 
      SQL*Plus Command Reference 
      Index 


Return to Oracle SQL*Plus

商品描述(中文翻譯)

描述:
儘管Oracle SQL*Plus廣泛可用且被使用,但很少有開發人員和資料庫管理員真正掌握其真正的威力。這本暢銷書籍現已更新至Oracle 10g版本,是對這個互動式查詢工具撰寫SQL腳本的深入指南。對於任何Oracle使用者來說,這是一個必不可少的資源。

《Oracle SQL*Plus: The Definitive Guide》的第二版清楚地描述了如何逐步執行Oracle開發人員和資料庫管理員想要使用SQL*Plus執行的所有任務,甚至可能還有一些您沒有意識到可以執行的任務。

使用《Oracle SQL*Plus: The Definitive Guide》,您將能夠:
- 編寫並執行腳本文件
- 生成臨時報表
- 從資料庫中提取數據
- 查詢資料字典表
- 自定義SQL*Plus環境
- 等等

它還包括對所有語法選項的方便快速參考,以及一個常被要求的關於SQL本身的章節,以及一個清晰、簡潔和完整的介紹。

這本書真正是SQL*Plus的權威指南。對於那些對SQL*Plus新手來說,它是一個不可或缺的資源;對於那些已經在使用SQL*Plus的人來說,它是一個以任務為導向的學習工具;對於每個使用者來說,它是一個立即可用的快速參考。如果您想充分利用這個受歡迎的Oracle工具的強大和靈活性,您將需要這本書。

目錄:
- 簡介
- 命令行SQL*Plus
- 開始SQL*Plus
- 輸入命令
- SQL*Plus命令中的字符串
- 指定文件名
- 命名變數
- 基於瀏覽器的SQL*Plus
- 開始和停止iSQL*Plus
- 連接到iSQL*Plus
- 連接到資料庫
- 作為SYSDBA連接
- 創建SYSDBA用戶
- 輸入並執行命令
- 以純文本形式獲取輸出
- 執行腳本
- 從iSQL*Plus斷開連接
- 選擇數據
- ...(省略部分內容)