You are previewing Oracle SQL Plus Pocket Reference, 2nd Edition.
O'Reilly logo
Oracle SQL Plus Pocket Reference, 2nd Edition

Book Description

SQL*Plus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQL*Plus can be. This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, "Oracle SQL8Plus: The Definitive Guide", into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQL*Plus Pocket Reference includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQL*Plus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop.

Table of Contents

  1. Oracle SQL*Plus Pocket Reference, 2nd Edition
    1. 1. Oracle SQL*PlusPocket Reference
      1. Introduction
        1. Acknowledgments
        2. Conventions
      2. Interacting with SQL*Plus
        1. Starting SQL*Plus
          1. Syntax for the sqlplus command
        2. Entering Commands
          1. Entering SQL*Plus commands
          2. Entering SQL statements
          3. Entering PL /SQL blocks
        3. Strings in SQL*Plus Commands
        4. Specifying Filenames
        5. Naming Variables
      3. Selecting Data
        1. The SELECT Statement
          1. Selecting columns from a table
          2. Ordering query results
          3. Restricting query results
          4. Using column aliases
        2. Null Values
          1. Using the NVL function
          2. Using the COALESCE function
        3. CASE Expressions
          1. Simple CASE expressions
          2. Searched CASE expressions
        4. Table Joins (Oracle8i)
          1. Inner and outer joins
        5. Table Joins (Oracle9i)
          1. Sample tables
          2. Inner joins
          3. Join order
          4. Left and right outer joins
          5. Full outer joins
          6. Specifying join conditions
        6. Summary Queries
          1. Using aggregate functions
          2. Using GROUP BY
          3. Restricting summarized results
          4. Using ALL and DISTINCT
        7. Unions
        8. Partition Operations
      4. Inserting Data
        1. Inserting One Row
        2. Inserting the Results of a Query
        3. Multitable Inserts (Oracle9i)
      5. Updating Data
        1. Simple Updates
        2. Noncorrelated Subqueries in the SET Clause
        3. Correlated Subqueries in the SET Clause
      6. Deleting Data
        1. Simple Deletes
        2. Deleting All Rows (TRUNCATE)
        3. Deleting Duplicate Rows
      7. Merging Data (Oracle9i)
      8. Transaction Management
        1. SET TRANSACTION
        2. SAVEPOINT
        3. COMMIT
        4. ROLLBACK
      9. Formatting Text Reports
        1. Column Headings
        2. Column Formats
        3. Page Width and Length
        4. Page Headers and Footers
          1. Defining a title
          2. Getting the date into a title
        5. Page Breaks
        6. Report Breaks
          1. The BREAK command
          2. The COMPUTE command
      10. Tuning SQL
        1. Creating the Plan Table
        2. Explaining a Query
          1. EXPLAIN PLAN syntax
          2. EXPLAIN PLAN example
        3. Querying the Plan Table
        4. Using Optimizer Hints
          1. Optimizer goal hints
          2. Access method hints
          3. Join order hints
          4. Join operation hints
          5. Query transformation hints
          6. Miscellaneous hints
      11. SQL*Plus Format Elements
        1. Formatting Numbers
        2. Formatting Character Strings
        3. Formatting Dates
      12. SQL*Plus Command Reference
        1. Introduction
        2. Comment Delimiters (/*...*/)
          1. Comment Delimiters (/*...*/)
        3. Double Hyphen ( -- )
          1. Double Hyphen ( -- )
        4. At Sign (@)
          1. At Sign (@)
        5. Double At Sign (@@)
          1. Double At Sign (@@)
        6. Forward Slash (/)
          1. Forward Slash (/)
        7. ACCEPT
          1. ACCEPT
        8. APPEND
          1. APPEND
        9. ARCHIVE LOG
          1. ARCHIVE LOG
        10. ATTRIBUTE
          1. ATTRIBUTE
        11. BREAK
          1. BREAK
        12. BTITLE
          1. BTITLE
        13. CHANGE
          1. CHANGE
        14. CLEAR
          1. CLEAR
        15. COLUMN
          1. COLUMN
        16. COMPUTE
          1. COMPUTE
        17. CONNECT
          1. CONNECT
        18. COPY
          1. COPY
        19. DEFINE
          1. DEFINE
        20. DEL
          1. DEL
        21. DESCRIBE
          1. DESCRIBE
        22. DISCONNECT
          1. DISCONNECT
        23. EDIT
          1. EDIT
        24. EXECUTE
          1. EXECUTE
        25. EXIT
          1. EXIT
        26. GET
          1. GET
        27. HELP
          1. HELP
        28. HOST
          1. HOST
        29. INPUT
          1. INPUT
        30. LIST
          1. LIST
        31. PASSWORD
          1. PASSWORD
        32. PAUSE
          1. PAUSE
        33. PRINT
          1. PRINT
        34. PROMPT
          1. PROMPT
        35. QUIT
          1. QUIT
        36. RECOVER
          1. RECOVER
        37. REMARK
          1. REMARK
        38. REPFOOTER
          1. REPFOOTER
        39. REPHEADER
          1. REPHEADER
        40. RUN
          1. RUN
        41. SAVE
          1. SAVE
        42. SET
          1. SET
        43. SHOW
          1. SHOW
        44. SHUTDOWN
          1. SHUTDOWN
        45. SPOOL
          1. SPOOL
        46. START
          1. START
        47. STARTUP
          1. STARTUP
        48. STORE
          1. STORE
        49. TIMING
          1. TIMING
        50. TTITLE
          1. TTITLE
        51. UNDEFINE
          1. UNDEFINE
        52. VARIABLE
          1. VARIABLE
        53. WHENEVER
          1. WHENEVER
    2. Index