Skip to content

Oracle SQL Plus Pocket Reference
Stock Photo: Cover May Be Different

Oracle SQL Plus Pocket Reference Paperback - 2004

by Jonathan Gennick


From the publisher

The Oracle SQL*Plus Pocket Reference is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQL*Plus. As Oracle's long-standing interactive query tool, SQL*Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQL*Plus is still often not completely understood or fully utilized. Database administrators and developers alike will therefore find the Oracle SQL*Plus Pocket Reference to be extremely beneficial. In addition to summarizing all of the SQL*Plus 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 SQL*Plus
  • Interact with SQL*Plus from both the command line and the web browser
  • Select, insert, update, and delete data
  • Format both text and HTML reports with SQL*Plus
  • Specify SQL*Plus 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 SQL*Plus 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 SQL*Plus, 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.

Details

  • Title Oracle SQL Plus Pocket Reference
  • Author Jonathan Gennick
  • Binding Paperback
  • Edition Third Edition
  • Pages 146
  • Volumes 1
  • Language ENG
  • Publisher O'Reilly Media, London
  • Date 2004-12-21
  • ISBN 9780596008857 / 0596008856
  • Weight 0.32 lbs (0.15 kg)
  • Dimensions 6.96 x 4.36 x 0.43 in (17.68 x 11.07 x 1.09 cm)
  • Library of Congress subjects Relational databases, Query languages (Computer science)
  • Dewey Decimal Code 005.756

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.

Back to Top

More Copies for Sale

Oracle SQL*Plus Pocket Reference : A Guide to SQL*Plus Syntax
Stock Photo: Cover May Be Different

Oracle SQL*Plus Pocket Reference : A Guide to SQL*Plus Syntax

by Gennick, Jonathan

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
2
Seller
Mishawaka, Indiana, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
A$8.10
FREE shipping to USA

Show Details

Description:
O'Reilly Media, Incorporated. Used - Good. Used book that is in clean, average condition without any missing pages.
Item Price
A$8.10
FREE shipping to USA
Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))
Stock Photo: Cover May Be Different

Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))

by Gennick, Jonathan

  • Used
Condition
Used - Good
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
1
Seller
Frederick, Maryland, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$9.16
A$6.18 shipping to USA

Show Details

Description:
O'Reilly Media. Used - Good. Good condition. 3rd edition. A copy that has been read but remains intact. May contain markings such as bookplates, stamps, limited notes and highlighting, or a few light stains. Bundled media such as CDs, DVDs, floppy disks or access codes may not be included.
Item Price
A$9.16
A$6.18 shipping to USA
Oracle SQL Plus Pocket Reference

Oracle SQL Plus Pocket Reference

by Gennick, Jonathan

  • Used
  • very good
  • Paperback
Condition
Used - Very Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$9.84
FREE shipping to USA

Show Details

Description:
O'Reilly Media, 2004. Paperback. Very Good. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
A$9.84
FREE shipping to USA
Oracle SQL Plus Pocket Reference

Oracle SQL Plus Pocket Reference

by Gennick, Jonathan

  • Used
  • good
  • Paperback
Condition
Used - Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
1
Seller
Seattle, Washington, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$9.84
FREE shipping to USA

Show Details

Description:
O'Reilly Media, 2004. Paperback. Good. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Item Price
A$9.84
FREE shipping to USA
Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly))
Stock Photo: Cover May Be Different

Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly))

by Jonathan Gennick

  • Used
  • Paperback
Condition
Used: Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
1
Seller
HOUSTON, Texas, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$12.22
FREE shipping to USA

Show Details

Description:
O'Reilly Media, 2004-11-18. Paperback. Used: Good.
Item Price
A$12.22
FREE shipping to USA
Oracle SQL?Plus Pocket Reference 3e (Pocket Reference (O'Reilly))

Oracle SQL?Plus Pocket Reference 3e (Pocket Reference (O'Reilly))

by Gennick, Jonathan

  • Used
  • very good
  • Paperback
Condition
Used - Very Good
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
4
Seller
GORING BY SEA, West Sussex, United Kingdom
Seller rating:
This seller has earned a 2 of 5 Stars rating from Biblio customers.
Item Price
A$16.75
A$16.61 shipping to USA

Show Details

Description:
Paperback. Very Good.
Item Price
A$16.75
A$16.61 shipping to USA
Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))
Stock Photo: Cover May Be Different

Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))

by Gennick, Jonathan

  • Used
  • Paperback
Condition
Like New
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
800
Seller
Fairfax Station, Virginia, United States
Seller rating:
This seller has earned a 2 of 5 Stars rating from Biblio customers.
Item Price
A$13.93
A$6.18 shipping to USA

Show Details

Description:
O'Reilly Media, 2004-12-07. Paperback. Like New.
Item Price
A$13.93
A$6.18 shipping to USA
Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))
Stock Photo: Cover May Be Different

Oracle SQL*Plus Pocket Reference: A Guide to SQL*Plus Syntax (Pocket Reference (O'Reilly))

by Gennick, Jonathan

  • New
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
800
Seller
Fairfax Station, Virginia, United States
Seller rating:
This seller has earned a 2 of 5 Stars rating from Biblio customers.
Item Price
A$14.29
A$6.18 shipping to USA

Show Details

Description:
O'Reilly Media, 2004-12-07. Paperback. New.
Item Price
A$14.29
A$6.18 shipping to USA
Oracle SqlPlus Pocket Reference (Pocket Reference (O'Reilly)): 3
Stock Photo: Cover May Be Different

Oracle SqlPlus Pocket Reference (Pocket Reference (O'Reilly)): 3

by Gennick, Jonathan

  • New
Condition
New
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
40
Seller
Benton Harbor, Michigan, United States
Seller rating:
This seller has earned a 5 of 5 Stars rating from Biblio customers.
Item Price
A$14.98
A$6.18 shipping to USA

Show Details

Description:
O'Reilly Media. New. BRAND NEW, GIFT QUALITY! NOT OVERSTOCKS OR MARKED UP REMAINDERS! DIRECT FROM THE PUBLISHER!
Item Price
A$14.98
A$6.18 shipping to USA
Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly))
Stock Photo: Cover May Be Different

Oracle SQL*Plus Pocket Reference (Pocket Reference (O'Reilly))

by Jonathan Gennick

  • Used
  • Paperback
Condition
Used:Good
Edition
Third Edition
Binding
Paperback
ISBN 10 / ISBN 13
9780596008857 / 0596008856
Quantity Available
1
Seller
HOUSTON, Texas, United States
Seller rating:
This seller has earned a 4 of 5 Stars rating from Biblio customers.
Item Price
A$18.11
FREE shipping to USA

Show Details

Description:
O'Reilly Media, 2004-11-18. Third Edition. Paperback. Used:Good.
Item Price
A$18.11
FREE shipping to USA