Oracle SQL Plus: The Definitive Guide

( 1 )

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

See more details below
Paperback (Second Edition)
$23.13
BN.com price
(Save 42%)$39.95 List Price

Pick Up In Store

Reserve and pick up in 60 minutes at your local store

Other sellers (Paperback)
  • All (18) from $1.99   
  • New (9) from $15.00   
  • Used (9) from $1.99   
Oracle SQL*Plus: The Definitive Guide

Available on NOOK devices and apps  
  • Nook Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.59
BN.com price
(Save 45%)$31.99 List Price

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.

Read More Show Less

Product Details

  • ISBN-13: 9780596007461
  • Publisher: O'Reilly Media, Incorporated
  • Publication date: 11/12/2004
  • Series: Definitive Guides Series
  • Edition description: Second Edition
  • Edition number: 2
  • Pages: 584
  • Sales rank: 560,246
  • Product dimensions: 7.00 (w) x 9.19 (h) x 1.11 (d)

Meet the Author

Jonathan Gennick is an O'Reilly & Associates editor specializing in database and programming titles. Prior to joining O'Reilly, Jonathan amassed some 17 years of programming and database management experience. During the latter part of his career he specialized in relational database programming, and more recently in database management. Jonathan got his start with relational database systems in 1990, first working with Ingres, and later with Digital's Rdb software. During that period he developed a fondness for SQL, and for the challenge of applying SQL creatively in ways that leveraged it's set-oriented capabilities. In 1994 Jonathan made the leap to Oracle, and is now often found writing about it. Recent projects include Oracle SQLLoader (O'Reilly & Associates, 2001); Oracle SQLPlus Pocket Reference (O'Reilly & Associates, 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly & Associates, 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly & Associates, 2002) and editing Practical PostgreSQL (O'Reilly & Associates, 2002). Jonathan is certified as an Oracle DBA and is a member of MENSA and the Oracle Technology Network. He holds a Bachelor of Arts degree in Information and Computer Science, with a Business Administration minor, from Andrews University in Berrien Springs, Michigan. Jonathan currently resides in Munising, Michigan with his wife Donna and their two children: Jenny and Jeff. Jonathan may be contacted by email at jonathan@gennick.com, and you can learn more about him personally by visiting his website at http://gennick.com.

Read More Show Less

Table of Contents


PrefaceChapter 1: Introduction to SQL*PlusChapter 2: Command-Line SQL*PlusChapter 3: Browser-Based SQL*PlusChapter 4: A Lightning SQL TutorialChapter 5: Generating Reports with SQL*PlusChapter 6: Creating HTML ReportsChapter 7: Advanced ReportsChapter 8: Writing SQL*Plus ScriptsChapter 9: Extracting and Loading DataChapter 10: Exploring Your DatabaseChapter 11: Advanced ScriptingChapter 12: Tuning and TimingChapter 13: The Product User ProfileChapter 14: Customizing Your SQL*Plus EnvironmentAppendix A: SQL*Plus Command ReferenceAppendix B: SQL*Plus Format ElementsColophon
Read More Show Less

Customer Reviews

Average Rating 4
( 1 )
Rating Distribution

5 Star

(0)

4 Star

(1)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted January 18, 2005

    the glories of the command line

    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.

    1 out of 1 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)