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 $0.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 Database Programming

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

Paperback

RRP $133.00

$64.75

51%
OFF

SQL Pocket Guide

A Guide to SQL Usage

Paperback

RRP $68.75

$35.99

48%
OFF

SQL Essentials For Dummies

For Dummies (Computer/Tech)

Paperback

RRP $27.95

$19.57

30%
OFF

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Paperback

RRP $125.75

$60.99

51%
OFF

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

Paperback

RRP $105.95

$92.75

12%
OFF

T-SQL Fundamentals

Developer Reference

Paperback

RRP $87.13

$77.75

11%
OFF

SQL Tuning

O'Reilly Ser.

Paperback

RRP $75.99

$39.75

48%
OFF

Domain-Specific Small Language Models - Guglielmo Iozzia

$55.75

51%
OFF

Data Pipelines with Apache Airflow, Second Edition : Orchestration for data and AI - Julian Ruiter

$47.75

50%
OFF

Transact-SQL Cookbook

Cookbooks Ser.

Paperback

RRP $76.00

$39.75

48%
OFF

Web Database Applications with PHP and MySQL

OREILLY

Paperback

RRP $95.00

$47.75

50%
OFF

Mastering Oracle SQL 2e

O'Reilly Ser.

Paperback

RRP $95.00

$47.75

50%
OFF

Oracle PL/SQL Best Practices

Write the Best PL/SQL Code of Your Life

Paperback

RRP $57.00

$30.75

46%
OFF

Perl Programming in easy steps

In Easy Steps

Paperback

RRP $55.99

$45.99

18%
OFF

97 Things Every Programmer Should Know

Collective Wisdom from the Experts

Paperback

RRP $76.00

$39.75

48%
OFF

Efficient MySQL Performance

Best Practices and Techniques

Paperback

RRP $125.75

$60.99

51%
OFF

SQL in a Nutshell

A Desktop Quick Reference

Paperback

RRP $152.00

$73.75

51%
OFF

Using SQLite

Small. Fast. Reliable. Choose Any Three.

Paperback

RRP $95.00

$47.75

50%
OFF

Rails, Angular, Postgres, and Bootstrap

Powerful, Effective, Efficient, Full-Stack Web Development

Paperback

RRP $75.95

$33.99

55%
OFF

High Performance MySQL

Proven Strategies for Running MySQL at Scale

Paperback

RRP $125.75

$60.99

51%
OFF

CockroachDB: The Definitive Guide

Distributed Data at Scale

Paperback

RRP $152.00

$79.75

48%
OFF

MySQL Cookbook

Solutions for Database Developers and Administrators

Paperback

RRP $171.00

$82.99

51%
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 Database Programming

Apache Iceberg: The Definitive Guide

Data Lakehouse Functionality, Performance, and Scalability on the Data Lake

SQL Pocket Guide

A Guide to SQL Usage

SQL Essentials For Dummies

For Dummies (Computer/Tech)

SQL Cookbook

Query Solutions and Techniques for All SQL Users 2nd Edition

Joe Celko's SQL Puzzles and Answers, Second Edition

The Morgan Kaufmann Series in Data Management Systems

T-SQL Fundamentals

Developer Reference

SQL Tuning

O'Reilly Ser.

Domain-Specific Small Language Models

Learning PHP, MySQL & JavaScript

A Step-by-Step Guide to Creating Dynamic Websites

Data Pipelines with Apache Airflow, Second Edition

Orchestration for data and AI

Learning Oracle PL/SQL

Learning Ser.

Transact-SQL Cookbook

Cookbooks Ser.

Web Database Applications with PHP and MySQL

OREILLY

Mastering Oracle SQL 2e

O'Reilly Ser.

Oracle PL/SQL Best Practices

Write the Best PL/SQL Code of Your Life

Perl Programming in easy steps

In Easy Steps

97 Things Every Programmer Should Know

Collective Wisdom from the Experts

Efficient MySQL Performance

Best Practices and Techniques

SQL in a Nutshell

A Desktop Quick Reference

Using SQLite

Small. Fast. Reliable. Choose Any Three.

Rails, Angular, Postgres, and Bootstrap

Powerful, Effective, Efficient, Full-Stack Web Development

High Performance MySQL

Proven Strategies for Running MySQL at Scale

CockroachDB: The Definitive Guide

Distributed Data at Scale

MySQL Cookbook

Solutions for Database Developers and Administrators

This product is categorised by