Oracle SQL*Plus: The Definitive Guide: The Definitive Guide

Oracle SQL*Plus: The Definitive Guide: The Definitive Guide

4.0 1
by Jonathan Gennick
     
 

View All Available Formats & Editions

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.
The new second edition of Oracle SQLPlus: The Definitive Guide

Overview

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.
The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.
With Oracle SQLPlus: The Definitive Guide, you'll expertly:
write and execute script files
generate ad hoc reports
extract data from the database
query the data dictionary tables
customize an SQLPlus environment
and much more
It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.
This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQLPlus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

Product Details

ISBN-13:
9780596552619
Publisher:
O'Reilly Media, Incorporated
Publication date:
11/16/2004
Series:
Definitive Guides
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
584
File size:
4 MB

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Oracle SQL Plus: The Definitive Guide 4 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
The glories of the command line. SQLPlus [I am not going to write that irritating asterix] is an acknowledgment of the reality that for many large computer programs and operating systems, a command line utility is vital. The book explains this for the specific instance of hooking to Oracle's database. It is meant as a definitive reference. Showing every command, often accompanied by example code. For an Oracle DBA, a good acquaintance with SQLPlus is probably mandatory. From the book, you can see how to quickly interrogate the database and get results in various useful paginated formats. Plus, and vitally, you can see how to build script files that can be run, where these files encode your experience in amassing customised sequences of commands specific to your needs. Exactly analogous to batch files in most operating systems, and just as useful. Along those lines, SQLPlus is conceptually not that hard. When using Oracle, it is often far more important, and harder, to design optimal tables for a given problem.