Oracle SQL Plus Pocket Reference

BUY THIS BOOK

Safari Books Online

Looking to Reprint this content?

Oracle SQL Plus Pocket Reference, Second Edition A Guide to SQL*Plus Syntax

By Jonathan Gennick
Second Edition October 2002
Pages: 120
Series: Pocket References
ISBN 10: 0-596-00441-9 | ISBN 13: 9780596004415

This book is OUT OF PRINT. Please consider the latest edition.

Book description

SQL*Plus 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. The "Oracle SQL*Plus Pocket Reference" boils down the most vital information from Gennick's best-selling book, "Oracle SQL*Plus: The Definitive Guide", into an accessible summary and works as a vital companion to the larger book. It summarizes all of the SQL*Plus syntax, including the syntax for the Oracle9i release.
Full Description

SQL*Plus 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 SQL*Plus can be. This pocket reference provides quick reference information that will help you use SQL*Plus, Oracle's interactive query tool. It summarizes all of the SQL*Plus 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 SQL*Plus, selecting data, formatting reports with SQL*Plus, and tuning SQL queries. It also contains quick references to the SQL*Plus commands and format elements. The new 2nd edition of our Oracle SQL*Plus 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 SQL*Plus 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.

Browse within this book

Cover | Table of Contents

Featured customer reviews

Be the first person to review this book!

Media reviews
"[Consumers] will find the fine 'pocket references' produced by O'Reilly to be compact and affordable."
-- James Cox, The Computer Shelf: Midwest Book Review

"'Oracle SQL*Plus' is a fantastic 'quick reference' for those little things that you tend to use then loose, such as altering tables using SQL or deleting duplicate rows. There is plenty of sample code or sample SQL as this case may be. It is written with big bold headers for the sections and the type is also big enough to use in a hurry! It also is chucked full of notes and warnings in areas where you can do some damage or bring the database to it's knees if you're not careful...This is a fantastic little book for web programmers as well as those who use SQL*Plus routinely. You can quickly find what you need and you'll most likely have a good example of the SQL you need to write. Anyone who writes queries against an Oracle database can get much good from this little jewel. I highly recommend it for web programmers who use Oracle."
--David Hannum, SEOMUG, Feb 2003

"A small but complete reference to SQL*Plus...contains concise yet helpful overviews of SQL actions, making the book a worthwhile tool for beginners and experts alike...Gennick points out the differences between Oracel8i/SQL syntax and Oracel9i/SQL syntax. This information alone makes the book a must-have reference for any Oracle user."
--Oracle Magazine, Feb 2003

Reviews From Previous Edition

Read all reviews

See larger cover