Oracle SQL Plus Pocket Reference

Jonathan Gennick

$28.50

Paperback

Not in-store but you can order this
How long will it take?

Availability Information

We source books from suppliers in Australia and overseas. For books we don't currently have in stock, the time it takes to get them from our suppliers can vary widely - from a few days to a few months - so we check each book with each supplier to determine the expected time it will take to be supplied to us.

We then advise you accordingly. If the time taken to get any book is too long for you, you can let us know and we will cancel or adjust your order, and refund as required.

To find out the anticipated arrival time for specific items prior to ordering, please contact us by phone or email:

Phone +61 2 9264 3111, or 1800 4 BOOKS (1800 4 26657) if outside Sydney:
option 1 Abbey's Bookshop (Crime, History, Science, Kids & more) • info@abbeys.com.au
option 2 Language Book Centre (ESL & Foreign Languages) • language@abbeys.com.au
option 3 Galaxy Bookshop (Sci-fi, Fantasy, Romance, Graphic Novels) • sf@galaxybooks.com.au

QTY:

English

O'Reilly Media
07 December 2004

Oracle

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 10g features, this handy, on-the-job guide specifically shows readers how to:

Differentiate between SQL and SQLPlus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQLPlus Specify SQLPlus 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 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 SQLPlus 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 SQLPlus: 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.

By: Jonathan Gennick
Imprint: O'Reilly Media
Country of Publication: United States
Edition: 3rd Revised edition
Dimensions: Height: 179mm, Width: 113mm, Spine: 11mm
Weight: 150g
ISBN: 9780596008857
ISBN 10: 0596008856
Pages: 146
Publication Date: 07 December 2004
Audience: General/trade , Professional and scholarly , ELT Advanced , Undergraduate
Format: Paperback
Publisher's Status: Active

Introduction Command-Line SQL*Plus Starting SQL*Plus Entering Commands Strings in SQL*Plus Commands Specifying Filenames Naming Variables Browser-Based SQL*Plus Starting and Stopping iSQL*Plus Connecting to iSQL*Plus Connecting to a Database Connecting as SYSDBA Creating SYSDBA Users; Entering and Executing Commands Getting Output as Plain Text; Executing Scripts Disconnecting from iSQL*Plus Selecting Data The SELECT Statement Nulls CASE Expressions; Table Joins (Oracle8i and Earlier) Table Joins (Oracle9i and Higher) Partition Outer Joins Summary Queries Unions; Partition Operations Flashback Queries Modeling Data; MODEL Clause Syntax MODEL Clause Functions MODEL Clause Example Inserting Data Inserting One Row Inserting the Results of a Query Multitable Inserts (Oracle9i and Higher); Updating Data Simple Updates Noncorrelated Subqueries in the SET Clause Correlated Subqueries in the SET Clause Deleting Data Simple Deletes Deleting All Rows (TRUNCATE) Deleting Duplicate Rows Merging Data (Oracle9i and Higher) Transaction Management SET TRANSACTION SAVEPOINT COMMIT ROLLBACK; Formatting Text Reports Column Headings Column Formats; Page Width and Length Page Headers and Footers Page Breaks; Report Breaks Formatting HTML Reports The Concatenation Approach Generating Full Pages Tuning SQL Creating the Plan Table Explaining a Query Using DBMS_XPLAN Querying the Plan Table Using Optimizer Hints SQL*Plus Format Elements Formatting Numbers Formatting Character Strings; Formatting Dates SQL*Plus Command Reference Index

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.