Skip to Main Content
Oracle SQL*Plus: The Definitive Guide
book

Oracle SQL*Plus: The Definitive Guide

by Jonathan Gennick
March 1999
Intermediate to advanced content levelIntermediate to advanced
528 pages
14h 39m
English
O'Reilly Media, Inc.
Content preview from Oracle SQL*Plus: The Definitive Guide

Objectives of This Book

The single, driving objective of this book is to help you squeeze every last possible ounce of productivity and usefulness out of SQL*Plus. If you read this book cover to cover, at the end you will have learned:

  • Methodical approaches to common tasks such as generating a report and extracting data to a flat file

  • How to enter and edit commands in the SQL*Plus environment, with and without an external editor

  • How to write simple scripts using SQL*Plus

  • How to prompt for user input and use that input in SQL commands, PL/SQL blocks, and SQL*Plus commands

  • How to stretch the limits of what you can do in a SQL*Plus script by implementing pseudo-IF statements, and by using one script to generate another

  • How the Product User Profile, an Oracle security feature, works with SQL*Plus

  • How to customize your SQL*Plus environment

  • How you can use SQL*Plus to view the definitions for database objects such as views, tables, constraints, triggers, indexes, and synonyms

  • How to use SQL*Plus as a tuning aid to maximize the performance of your SQL queries

An additional objective of this book is to serve as a ready reference you can pull out when faced with a common task. If you need to generate a report, open to the chapter on reports and follow the steps. Need to extract data? Open to the chapter on data extraction, and again just follow the steps. Every effort has been made to organize the information topically, so that all the information you need to accomplish a specific task is in one ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Jonathan Gennick
Oracle PL/SQL Programming, Third Edition

Oracle PL/SQL Programming, Third Edition

Steven Feuerstein, Bill Pribyl
Oracle SQL

Oracle SQL

Dan Hotka

Publisher Resources

ISBN: 1565925785Supplemental ContentCatalog PageErrata