Publisher: O'Reilly Media Released: October 2002 Pages: 128
SQLPlus is available at every Oracle site--from the largest data warehouse to the smallest single-user system--and it's a critical tool for virtually every Oracle user. Despite its wide use, few developers and DBAs know how powerful a tool SQLPlus can be. This pocket reference provides quick reference information that will help you use SQLPlus, Oracle's interactive query tool. It summarizes all of the SQLPlus syntax, including the syntax for the Oracle9i release. This book boils down the most vital information from Gennick's best-selling book, "Oracle SQL8Plus: The Definitive Guide", into an accessible summary and works as a vital companion to the larger book. It concisely describes interacting with SQLPlus, selecting data, formatting reports with SQLPlus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQLPlus Pocket Reference includes many new features for Oracle9i (e.g., COALESCE function, searched CASE expressions, new table join syntax, partition operations, MERGE statement, and syntax changes in existing SQLPlus statements such as ACCEPT, DESRIBE, HELP, and SET) It also adds sections on basic SQL (a much-requested feature): INSERT, DELETE, UPDATE, SELECT, and transaction management. The pocket reference size is especially appropriate for this particular subject, since Oracle SQL*Plus is used on every possible platform, it's particularly convenient to be able to carry a small book around from office computer to home computer to laptop. |
-
Chapter 1 Oracle SQL*PlusPocket Reference -
Introduction -
Interacting with SQL*Plus -
Selecting Data -
Inserting Data -
Updating Data -
Deleting Data -
Merging Data (Oracle9i) -
Transaction Management -
Formatting Text Reports -
Tuning SQL -
SQL*Plus Format Elements -
SQL*Plus Command Reference
|
- Title:
- Oracle SQL Plus Pocket Reference, 2nd Edition
- By:
- Jonathan Gennick
- Publisher:
- O'Reilly Media
- Formats:
-
- Print:
- October 2002
- Pages:
- 128
- Print ISBN:
- 978-0-596-00441-5
- | ISBN 10:
- 0-596-00441-9
|
-
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 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. View Jonathan Gennick's full profile page. |
|
Description
|
Table of Contents
|
Product Details
|
About the Author
|
 |
|
|
|
|
|
Recommended for You
|
Recently Viewed
|
|
|
By Joe Kissell
September 2007
By Joe Kissell
October 2006
By Joe Kissell
September 2007
|
Customer Reviews
|
|
|
