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

Jonathan Gennick

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




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:

      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 
                CASE Expressions 
                Table Joins (Oracle8i and Earlier) 
                Table Joins (Oracle9i and Higher) 
                Partition Outer Joins 
                Summary Queries 
                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 
      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 

Return to Oracle SQL*Plus