Oracle SQL*Plus: The Definitive Guide

This definitive guide to SQL*Plus, Oracle's interactive query tool, shows Oracle developers and database administrators how to take full advantage of the power and flexibility of this popular tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, includes a quick reference to its syntax options, and provides chapters that describe, step-by-step, how to perform all the tasks Oracle developers and DBAs want to perform with SQL*Plus -- and maybe some they didn't realize they COULD perform. You will learn how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, customize your SQL*Plus environment, and use the SQL*Plus administrative features (new in Oracle8i). Oracle SQL*Plus: The Definitive Guide is an indispensable resource for readers who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and a quick reference for every user.