Oracle SQL Plus Pocket Reference

By: Jonathan Gennick

Write A Review

Paperback | 7 December 2004 | Edition Number 3

At a Glance

Paperback
146 Pages

Edition Type
Revised

Dimensions(cm)
17.9 x 10.9 x 1.0

Paperback

RRP $28.50

$16.99

40%OFF

or 4 interest-free payments of $4.25 with

Ships in 15 to 25 business days

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.

Shipping

	Standard Shipping	Express Shipping
Metro postcodes:	$9.99	$14.95
Regional postcodes:	$9.99	$14.95
Rural postcodes:	$9.99	$14.95

Orders over $79.00 qualify for free shipping.

How to return your order

At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.

Additional postage charges may be applicable.

Defective items

If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.

For more info please visit our Help Centre.

More in Oracle

Oracle in a Nutshell

In a Nutshell (O'Reilly)

Paperback

RRP $104.75

$51.75

51%
OFF

Oracle DBA Checklists Pocket Reference

POCKET REFERENCES

Not Supplied By Publisher

RRP $18.99

$12.75

33%
OFF

Oracle PL/SQL Programming

Paperback

RRP $152.00

$89.99

41%
OFF

UNIX for Oracle DBAs Pocket Reference

Command Syntax and Scripts

Paperback

RRP $18.99

$12.75

33%
OFF

Learning Oracle PL/SQL

Learning Ser.

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle Data Dictionary Pocket Reference

Views, Columns & Tips

Paperback

RRP $18.99

$12.75

33%
OFF

Mastering Oracle SQL 2e

O'Reilly Ser.

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle Essentials

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle 12c: SQL

3rd Edition

Paperback

RRP $167.95

$146.75

13%
OFF

The Promethean Oracle

Boxed, Slipcased or Casebound

RRP $62.99

$60.75

Nature's Hidden Oracles

From Flowers to Feathers & Shells to Stones - A Practical Guide to Natural Divination

Hardcover

RRP $34.99

$32.75

Oracle8i Backup and Recovery : Oracle Press - Rama Velpuri

$51.75

50%
OFF

Oracle SQL*Loader: The Definitive Guide

Loading Data into an Oracle Database

Not Supplied By Publisher

RRP $76.00

$39.75

48%
OFF

Oracle8i Internal Servies for Waits; Latches; Locks & Memory

OREILLY

Not Supplied By Publisher

RRP $47.50

$26.75

44%
OFF

Oracle Internals

Tips, Tricks, and Techniques for DBAs

Paperback

RRP $231.00

$202.75

12%
OFF

Oracle RMAN Pocket Reference

Paperback

RRP $18.90

$12.75

33%
OFF

Oracle9i DBA Handbook

Oracle Books

Paperback

RRP $116.95

$93.75

20%
OFF

Oracle Manufacturing and Supply Chain Handbook : Oracle Press - Bastin Gerald

$219.75

13%
OFF

Oracle9i UNIX Administration Handbook

Oracle Press

Paperback

RRP $99.95

$81.99

18%
OFF

Oracle9i High-Performance Tuning with STATSPACK

Oracle Press

Paperback

RRP $118.95

$94.75

20%
OFF

Oracle SQL Tuning Pocket Reference

Pocket References

Paperback

RRP $18.90

$12.75

33%
OFF

Java Programming with Oracle JDBC

Java Ser.

Paperback

RRP $104.50

$51.75

50%
OFF

Introduction	p. 1
Command-Line SQL*Plus	p. 3
Starting SQL*Plus	p. 3
Entering Commands	p. 6
Strings in SQL*Plus Commands	p. 9
Specifying Filenames	p. 9
Naming Variables	p. 10
Browser-Based SQL*Plus	p. 10
Starting and Stopping iSQL*Plus	p. 11
Connecting to iSQL*Plus	p. 11
Connecting to a Database	p. 12
Connecting as SYSDBA	p. 13
Creating SYSDBA Users	p. 15
Entering and Executing Commands	p. 16
Getting Output as Plain Text	p. 16
Executing Scripts	p. 17
Disconnecting from iSQL*Plus	p. 18
Selecting Data	p. 19
The SELECT Statement	p. 19
Nulls	p. 23
CASE Expressions	p. 25
Table Joins (Oracle8i and Earlier)	p. 27
Table Joins (Oracle9i and Higher)	p. 28
Partition Outer Joins	p. 35
Summary Queries	p. 38
Unions	p. 41
Partition Operations	p. 42
Flashback Queries	p. 43
Modeling Data	p. 44
MODEL Clause Syntax	p. 44
MODEL Clause Functions	p. 49
MODEL Clause Example	p. 50
Inserting Data	p. 52
Inserting One Row	p. 53
Inserting the Results of a Query	p. 53
Multitable Inserts (Oracle9i and Higher)	p. 54
Updating Data	p. 55
Simple Updates	p. 55
Noncorrelated Subqueries in the SET Clause	p. 56
Correlated Subqueries in the SET Clause	p. 56
Deleting Data	p. 57
Simple Deletes	p. 57
Deleting All Rows (TRUNCATE)	p. 57
Deleting Duplicate Rows	p. 58
Merging Data (Oracle9i and Higher)	p. 59
Transaction Management	p. 62
SET TRANSACTION	p. 63
SAVEPOINT	p. 64
COMMIT	p. 64
ROLLBACK	p. 64
Formatting Text Reports	p. 65
Column Headings	p. 65
Column Formats	p. 66
Page Width and Length	p. 66
Page Headers and Footers	p. 67
Page Breaks	p. 68
Report Breaks	p. 68
Formatting HTML Reports	p. 70
The Concatenation Approach	p. 71
Generating Full Pages	p. 74
Tuning SQL	p. 76
Creating the Plan Table	p. 77
Explaining a Query	p. 78
Using DBMS_XPLAN	p. 80
Querying the Plan Table	p. 81
Using Optimizer Hints	p. 83
SQL*Plus Format Elements	p. 89
Formatting Numbers	p. 90
Formatting Character Strings	p. 92
Formatting Dates	p. 93
SQL*Plus Command Reference	p. 96
Index	p. 139
Table of Contents provided by Ingram. All Rights Reserved.

Oracle SQL Plus Pocket Reference

At a Glance

Paperback

Shipping

How to return your order

Defective items

You Can Find This Book In

More in Oracle

Oracle in a Nutshell

In a Nutshell (O'Reilly)

Oracle DBA Checklists Pocket Reference

POCKET REFERENCES

Oracle PL/SQL Programming

UNIX for Oracle DBAs Pocket Reference

Command Syntax and Scripts

Learning Oracle PL/SQL

Learning Ser.

Oracle Data Dictionary Pocket Reference

Views, Columns & Tips

Mastering Oracle SQL 2e

O'Reilly Ser.

Oracle Essentials

Oracle 12c: SQL

3rd Edition

The Promethean Oracle

Nature's Hidden Oracles

From Flowers to Feathers & Shells to Stones - A Practical Guide to Natural Divination

Oracle8i Backup and Recovery

Oracle Press

Oracle and Open Source

Includes Perl, Linux, Tcl, Python, Apache, Java and More

Oracle SQL*Loader: The Definitive Guide

Loading Data into an Oracle Database

Oracle8i Internal Servies for Waits; Latches; Locks & Memory

OREILLY

Oracle Internals

Tips, Tricks, and Techniques for DBAs

Oracle RMAN Pocket Reference

Oracle9i DBA Handbook

Oracle Books

Oracle Manufacturing and Supply Chain Handbook

Oracle Press

Physical Database Design Using Oracle

Foundations of Database Design

Oracle9i UNIX Administration Handbook

Oracle Press

Oracle9i High-Performance Tuning with STATSPACK

Oracle Press

Oracle SQL Tuning Pocket Reference

Pocket References

Java Programming with Oracle JDBC

Java Ser.

This product is categorised by