Buying Options
Oracle SQL Plus Pocket Reference, Second Edition
This product is no longer available.

Please consider the latest edition.

Oracle SQL Plus Pocket Reference, Second Edition

A Guide to SQL*Plus Syntax

By
Jonathan Gennick
Publisher:
O'Reilly Media
Released:
October 2002
Pages:
128

Product Editions

  1. Oracle SQL*Plus Pocket Reference, Third Edition - November 2004
  2. Oracle SQL Plus Pocket Reference, Second Edition - October 2002 (out of print)
  3. Oracle SQL*Plus Pocket Reference - April 2000 (out of print)
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
Table of Contents

  1. Chapter 1 Oracle SQL*PlusPocket Reference

    1. Introduction

    2. Interacting with SQL*Plus

    3. Selecting Data

    4. Inserting Data

    5. Updating Data

    6. Deleting Data

    7. Merging Data (Oracle9i)

    8. Transaction Management

    9. Formatting Text Reports

    10. Tuning SQL

    11. SQL*Plus Format Elements

  2. Chapter 2 SQL*Plus Command Reference

    1. Introduction

    2. Comment Delimiters (/*...*/)

    3. Double Hyphen ( -- )

    4. At Sign (@)

    5. Double At Sign (@@)

    6. Forward Slash (/)

    7. ACCEPT

    8. APPEND

    9. ARCHIVE LOG

    10. ATTRIBUTE

    11. BREAK

    12. BTITLE

    13. CHANGE

    14. CLEAR

    15. COLUMN

    16. COMPUTE

    17. CONNECT

    18. COPY

    19. DEFINE

    20. DEL

    21. DESCRIBE

    22. DISCONNECT

    23. EDIT

    24. EXECUTE

    25. EXIT

    26. GET

    27. HELP

    28. HOST

    29. INPUT

    30. LIST

    31. PASSWORD

    32. PAUSE

    33. PRINT

    34. PROMPT

    35. QUIT

    36. RECOVER

    37. REMARK

    38. REPFOOTER

    39. REPHEADER

    40. RUN

    41. SAVE

    42. SET

    43. SHOW

    44. SHUTDOWN

    45. SPOOL

    46. START

    47. STARTUP

    48. STORE

    49. TIMING

    50. TTITLE

    51. UNDEFINE

    52. VARIABLE

    53. WHENEVER

    View Full Table of Contents
    Product Details
    Title:
    Oracle SQL Plus Pocket Reference, Second Edition
    By:
    Jonathan Gennick
    Publisher:
    O'Reilly Media
    Formats:
    • Print
    Print Release:
    October 2002
    Pages:
    128
    Print ISBN:
    978-0-596-00441-5
    | ISBN 10:
    0-596-00441-9
    Customer Reviews
    About the Author

    1. 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 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.

    • Book cover of Oracle SQL Plus Pocket Reference
    Got a Question?
    icons
    Favicon Service and support by Satisfaction