Oracle SQL*Plus: pocket reference

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 s.

"Covers Oracle database 10g"--Cover

Includes index.

Oracle SQL*Plus Pocket Reference; Introduction; Acknowledgments; Conventions; Command-Line SQL*Plus; Starting SQL*Plus; Syntax for the sqlplus command; Entering Commands; Entering SQL*Plus commands; Entering SQL statements; Entering PL/SQL blocks; 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 DataThe SELECT Statement; Selecting columns from a table; Ordering query results; Restricting query results; Using column aliases; Factoring out subqueries; Nulls; Using the NVL function; Using the COALESCE function; CASE Expressions; Simple CASE expressions; Searched CASE expressions; Table Joins (Oracle8i and Earlier); Inner and outer joins; Table Joins (Oracle9i and Higher); Sample tables; Inner joins; Join order; Left and right outer joins; Full outer joins; Specifying join conditions; Partition Outer Joins; Summary Queries; Using aggregate functions; Using GROUP BY

Restricting summarized resul…