Oracle SQL*Plus Pocket Reference, 3/e

Jonathan Gennick

  • 出版商: O'Reilly
  • 出版日期: 2004-12-07
  • 售價: $670
  • 貴賓價: 9.5$637
  • 語言: 英文
  • 頁數: 154
  • 裝訂: Paperback
  • ISBN: 0596008856
  • ISBN-13: 9780596008857
  • 相關分類: OracleSQL
  • 已過版




The Oracle SQL*Plus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle's long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized.

Database administrators and developers alike will therefore find the Oracle SQL*Plus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQL*Plus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:

  • Differentiate between SQL and SQL*Plus
  • Interact with SQL*Plus from both the command line and the web browser
  • Select, insert, update, and delete data
  • Format both text and HTML reports with SQL*Plus
  • Specify SQL*Plus commands and format elements
  • Tune SQL queries

The new third edition of this book has been updated for Oracle Database 10g to include information on both SQL*Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.

With its quick-reference format and compact size, the Oracle SQL*Plus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQL*Plus, the bestselling Oracle SQL*Plus: The Definitive Guide.

Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.


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