Oracle SQL Plus Pocket Reference 3rd Edition

Description

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

Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus 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 SQLPlus
* Interact with SQLPlus from both the command line and the web browser
* Select, insert, update, and delete data
* Format both text and HTML reports with SQLPlus
* Specify SQLPlus 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 SQLPlus 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 SQLPlus, 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.

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