Oracle SQL*Plus : pocket reference

Author(s)

Bibliographic Information

Oracle SQL*Plus : pocket reference

Jonathan Gennick

O'Reilly, 2002, c2003

2nd ed

Available at  / 1 libraries

Search this Book/Journal

Note

Includes index

On cover: Covers Oracle9i

Description and Table of Contents

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 offers 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 SQL*Plus: 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. This 2nd edition 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

Introduction Interacting with SQL*Plus Starting SQL*Plus Entering Commands Strings in SQL*Plus Commands Specifying Filenames Naming Variables Selecting Data The SELECT Statement Null Values CASE Expressions Table Joins (Oracle8i) Table Joins (Oracle9i) Summary Queries Unions Partition Operations Inserting Data Inserting One Row Inserting the Results of a Query Multitable Inserts (Oracle9i) 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) Transaction Management SET TRANSACTION SAVEPOINT COMMIT ROLLBACK Text Reports Column Headings Column Formats Page Width and Length Page Headers and Footers Page Breaks Report Breaks Tuning SQL Creating the Plan Table Explaining a Query Querying the Plan Table Using Optimizer Hints SQL*Plus Format Elements Formatting Numbers Formatting Character Strings Formatting Dates SQL*Plus Command Reference Index

by "Nielsen BookData"

Details

Page Top