Oracle SQL*Plus: The Definitive Guide
Publisher: O'Reilly Media
Released: March 1999
Pages: 528

This book is the definitive guide to SQL*Plus. If you want to take best advantage of the power and flexibility of this popular Oracle tool, you need this book.

SQLPlus is an interactive query tool that is ubiquitous in the Oracle world. It is present in every Oracle installation and is available to almost every Oracle developer and database administrator. SQLPlus has been shipped with Oracle since at least version 6. It continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. It is still the only widely available tool for writing SQL scripts. Despite this wide availability and usage, few developers and DBAs know how powerful SQL*Plus really is.

This book introduces SQLPlus, includes a quick reference to all of its syntax options, and, most important, provides chapters that describe, in step-by-step fashion, how to perform all of the tasks that Oracle developers and DBAs want to perform with SQLPlus -- and maybe some they didn't realize they COULD perform with SQLPlus. 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 SQLPlus environment, and use the SQL*Plus administrative features (new in Oracle8i).

This book 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.

A table of contents follows:

  • Preface
  • Introduction to SQLPlus
  • Interacting with SQLPlus
  • Generating Reports with SQLPlus
  • Writing SQLPlus Scripts
  • Extracting Data with SQLPlus
  • Exploring Your Database with SQLPlus
  • Advanced Scripting
  • Tuning and Timing
  • The Product User Profile
  • Administration with SQLPlus
  • Customizing Your SQLPlus Environment
Appendices
  • A. SQLPlus Command Reference
  • B. Connect Strings and the SQLPlus Command
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyOracle SQL*Plus: The Definitive Guide
 
5.0

(based on 5 reviews)

Ratings Distribution

  • 5 Stars

     

    (5)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 5 customers

Sort by

Displaying reviews 1-5

Back to top

 
5.0

Excellent series. Check for latest edition

By jdruin

from Undisclosed

Comments about oreilly Oracle SQL*Plus: The Definitive Guide:

This particular edition is out of date since it covered 8i, but the book has been updated with newer editions which are excellent.

 
5.0

A Must Have""

By jdruin

from Undisclosed

Comments about oreilly Oracle SQL*Plus: The Definitive Guide:

As a frequent user of SQL Plus, this book is very handy. For many tasks we use Oracle SQL Developer but in many cases SQL Plus is an easier tool to use for scripting. However the scripting syntax and the abilities of SQL Plus can be difficult to fully utilize. This book does a great job of explaining what SQL Plus can do and how to use the tools. In additioning to covering querying techniques, the chapters on generating reports in a quick but structured fashion were useful. I ended up getting 3 more copies for my team as my copy kept wandering around the room.

 
5.0

Great overview

By Sam

from Undisclosed

Comments about oreilly Oracle SQL*Plus: The Definitive Guide:

Very well organized, good examples, good writing. I was able to get out of it what I needed in a weekend. Nice job.

 
5.0

Oracle SQL*Plus: The Definitive Guide Review

By Sharon Close

from Undisclosed

Comments about oreilly Oracle SQL*Plus: The Definitive Guide:

Thank you for a superb introduction to SQLPLUS. I can definitely be described as a novice - I attended an Oracle sql for end users course two years ago, but found it a difficult subject to grasp as I had no experience of using sql (and sharing a pc with another trainee did not help!). I thought I was doomed never to use it again.

I went into a shop two days ago looking for SQL for Dummies, but discovered your far more useful book and have suddenly discovered I can do it after all! I have impressed myself with my new found ability to write scripts (with lots of joins) and correctly format reports - a major breakthrough for a new consultant in the marketplace.

Thank you once again - this is the best value for money in the marketplace.

 
5.0

Oracle SQL*Plus: The Definitive Guide Review

By K Vainstein

from Undisclosed

Comments about oreilly Oracle SQL*Plus: The Definitive Guide:

Just like the cover says - Definitive. My one complaint is that command-line arguments aren't in the book's index, although they're used in a few of the example scripts. (Call them &&1, &&2, etc. Here's a good approach - at start of script, have something like

PRO Inputs:

PRO 1: schema name

PRO 2: column name

, and then user will get an explanation of what args were expected. If the command-line args weren't entered, SQL*Plus will give another opportunity to enter them, as in

Enter value for 1:

, so forth. Looks nice.)

The Ukrainian names are literary, not historical (off-the-wall correction of an earlier reader comment).

Truly superior technical text.

Displaying reviews 1-5

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?