Oracle SQL*Plus Pocket Reference, 3/e
暫譯: Oracle SQL*Plus 口袋參考手冊，第3版

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