25 Women to Read Before You Die

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to PowellsBooks.news
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Q&A | August 26, 2015

    Christopher Moore: IMG Powell’s Q&A: Christopher Moore

    Describe your latest book. Secondhand Souls is the sequel to my bestselling novel A Dirty Job, which was about a single dad in San Francisco who... Continue »
    1. $18.89 Sale Hardcover add to wish list

      Secondhand Souls

      Christopher Moore 9780061779787


Oracle SQL Plus Pocket Reference 3RD Edition


Oracle SQL Plus Pocket Reference 3RD Edition Cover


Synopses & Reviews

Publisher Comments:

The Oracle SQLPlus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQLPlus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQLPlus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10g features, this handy, on-the-job guide specifically shows readers how to:

  • Differentiate between SQL and SQLPlus
  • Interact with SQLPlus from both the command line and the web browser
  • Select, insert, update, and delete data
  • Format both text and HTML reports with SQLPlus
  • Specify SQLPlus commands and format elements
  • Tune SQL queries
The new third edition of this book has been updated for Oracle Database 10g to include information on both SQLPlus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Oracle SQLPlus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQLPlus, the bestselling Oracle SQLPlus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience.

About the Author

Jonathan Gennick is an O'Reilly Media, Inc. 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 Media, Inc., 2001); Oracle SQLPlus Pocket Reference (O'Reilly Media, Inc., 2000); Oracle SQL*Plus: The Definitive Guide (O'Reilly Media, Inc., 1999); More recently, Jonathan has made forays into other database products, coauthoring Transact-SQL Cookbook (O'Reilly Media, Inc., 2002) and editing Practical PostgreSQL (O'Reilly Media, Inc., 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.

Table of Contents

  • Chapter 1: Oracle SQL*Plus Pocket Reference
  • Oreilly®: Oracle SQL*Plus Pocket Reference

Product Details

Gennick, Jonathan
O'Reilly Media
Programming Languages - SQL
Database Management - General
Relational databases
SQL*PLUS (Computer program language)
Query languages (Computer science)
Computer Languages-SQL
CourseSmart Subject Description
Edition Number:
Edition Description:
Third Edition
Pocket Reference (O'Reilly)
Publication Date:
6.96x4.36x.43 in. .32 lbs.

Other books you might like

  1. Moving to ASP.NET: Web Development... New Trade Paper $49.95
  2. Sendmail: Theory and Practice New Trade Paper $95.75
  3. Xml Pocket Reference 3RD Edition Used Trade Paper $5.21
  4. Expert Oracle Database Architecture:... Used Trade Paper $14.95
  5. Using CSH & Tcsh (Nutshell Handbooks) Used Trade Paper $18.00

Related Subjects

Computers and Internet » Computer Languages » SQL
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Networking » General
Computers and Internet » Nutshell » General
Computers and Internet » Software Engineering » Software Management

Oracle SQL Plus Pocket Reference 3RD Edition Used Trade Paper
0 stars - 0 reviews
$6.95 In Stock
Product details 154 pages O'Reilly & Associates - English 9780596008857 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.