Oracle SQL Plus: Pocket Reference

by Gennick, Jonathan

• ISBN13: 9781565929418
• ISBN10: 1565929411
• Format: Paperback
• Copyright: 2000-05-01
• Publisher: Oreilly & Associates Inc

Summary

This pocket reference provides quick reference information that will help you use SQLPlus, Oracle's interactive query tool. It summarizes all of the SQLPlus syntax, including the syntax for new Oracle8irelease 8.1.6 features.SQLPlus 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 SQLPlus can be.This book boils down the most vital information from Gennick's best-selling book,Oracle SQLPlus: The Definitive Guide, into an accessible summary. It concisely describes interacting with SQLPlus, selecting data, formatting reports with SQLPlus, and tuning SQL queries. It also contains quick references to the SQLPlus commands and format elements.This book is an indispensable companion to O'Reilly bestselling book,Oracle SQLPlus: The Definitive Guide, but it does not replace it; the larger book is truly the definitive guide, suitable for readers at all levels of expertise. The definitive guide describes the many tasks that SQLPlus can perform, and provides a tutorial on many SQLPlus topics. But this quick reference is an excellent, portable resource for readers who want a pocket-sized summary of SQLPlus capabilities and a reminder of how to issue specific commands and formatting options for SQL*Plus.Table of Contents: Interacting with SQLPlus Selecting Data Formatting Reports Tuning SQL SQLPlus Format Elements SQL*Plus Command Reference

Table of Contents

Introduction	p. 1
Acknowledgments	p. 1
Conventions	p. 2
Interacting with SQL*Plus	p. 2
Starting SQL*Plus	p. 2
Entering Commands	p. 5
Strings in SQL*Plus Commands	p. 7
Specifying Filenames	p. 7
Naming Variables	p. 8
Selecting Data	p. 9
The SELECT Statement	p. 9
Null Values	p. 11
Table Joins	p. 12
Summary Queries	p. 14
Unions	p. 17
Formatting Reports	p. 18
Column Headings	p. 18
Column Formats	p. 19
Page Width and Length	p. 19
Page Headers and Footers	p. 20
Page Breaks	p. 21
Report Breaks	p. 21
Tuning SQL	p. 24
Creating the Plan Table	p. 24
Explaining a Query	p. 25
Querying the Plan Table	p. 26
Using Optimizer Hints	p. 31
SQL*Plus Format Elements	p. 36
Formatting Numbers	p. 36
Formatting Character Strings	p. 38
Formatting Dates	p. 39
SQL*Plus Command Reference	p. 42
Table of Contents provided by Syndetics. All Rights Reserved.