Oracle SQLPlus Pocket Reference by Jonathan Gennick
Look inside with Google Book Preview
Oracle SQLPlus Pocket Reference
By Jonathan Gennick

Oracle SQLPlus Pocket Reference

3rd Revised edition

By (author) See other recent books by Jonathan Gennick
Format: Paperback

Normal Price: $28.82
Your Price: $25.94 AUD, inc. GST
Shipping: $7.95 per order
You Save: $2.88! (10% off normal price)
Plus...earn $1.30 in Boomerang Bucks
Availability: Available Available, ships in 8-11 days

Oracle SQLPlus Pocket Reference by Jonathan Gennick

Book Description

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 10"g" features, this handy, on-the-job guide specifically shows readers how to: Differentiate between SQL and SQLPlusInteract with SQLPlus from both the command line and the web browserSelect, insert, update, and delete dataFormat both text and HTML reports with SQLPlusSpecify SQLPlus commands and format elementsTune SQL queriesThe new third edition of this book has been updated for Oracle Database 10"g" 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 SQL"Plus 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 SQL"Plus: 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.

Buy Oracle SQLPlus Pocket Reference book by Jonathan Gennick from Australia's Online Bookstore, Boomerang Books.

Book Details

ISBN: 9780596008857
ISBN-10: 0596008856
Format: Paperback
(179mm x 113mm x 11mm)
Pages: 146
Imprint: O'Reilly Media, Inc, USA
Publisher: O'Reilly Media, Inc, USA
Publish Date: 7-Dec-2004
Country of Publication: United States

Books By Author Jonathan Gennick

SQL Pocket Guide by Jonathan Gennick SQL Pocket Guide, Paperback (December 2010)

For programmers and database administrators who use SQL in their day-to-day work, this popular pocket guide is the ideal on-the-job reference. It uses numerous examples to address the language's complexity, and covers key aspects of SQL used in Oracle, DB2, SQL Server, MySQL, and PostgreSQL.

Oracle SQL*Plus The Definitive Guide by Jonathan Gennick Oracle SQL*Plus The Definitive Guide, Paperback (December 2004)

Updated for Oracle 10g, this guide to SQL*Plus describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform. If you want to leverage of the full power and flexibility of this popular Oracle tool, this book is a useful resource.

Oracle Regular Expressions Pocket Reference by Jonathan Gennick Oracle Regular Expressions Pocket Reference, Paperback (September 2003)

This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions.

Oracle SQL*Loader by Jonathan Gennick Oracle SQL*Loader, Paperback (May 2001)

This text describes all of SQL*Loader's functions, including how to construct the necessary control files, load different types of data, and get the best performance. It covers the newest SQL*Loader features for 2001.

» View all books by Jonathan Gennick


» Have you read this book? We'd like to know what you think about it - write a review about Oracle SQLPlus Pocket Reference book by Jonathan Gennick and you'll earn 50c in Boomerang Bucks loyalty dollars (you must be a member - it's free to sign up!)

Write a book review

Author Biography - Jonathan Gennick

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 SQL*Loader (O'Reilly & Associates, 2001); Oracle SQL*Plus 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, and you can learn more about him personally by visiting his website at

Boomerang Bucks close

For every $20 you spend on books, you will receive $1 in Boomerang Bucks loyalty dollars. You can use your Boomerang Bucks as a credit towards a future purchase from Boomerang Books. Note that you must be a Member (free to sign up) and that conditions do apply.

Recent books by Jonathan Gennick close
SQL Pocket Guide by Jonathan Gennick
Oracle SQL*Plus The Definitive Guide by Jonathan Gennick
Oracle Regular Expressions Pocket Reference by Jonathan Gennick
Oracle SQL*Loader by Jonathan Gennick
» close