|
Oracle SQL Plus Pocket Reference 3rd Edition
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.
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
|
