Book Reviews   Digital Libraries   Astronomy Log   Software   About  
Brainshed Reviews: Oracle SQL*Plus Pocket Reference
Oracle SQL*Plus Pocket Reference
Author: Jonathan Gennick
Pages: 90
Publisher: O'Reilly & Associates
ISBN: 1-56592-941-1
Summary: A very helpful reference to Oracle's spartan-at-first-glance command-line interface.
Review Date: 8 May, 2002

At first glance, Oracle's SQL*Plus command-line interface may appear clunky and weak, compared to the likes of the handy readline-enabled CLI offerings from MySQL and Postgresql. But experienced Oracle users know that once you get under the surface of SQL*Plus, it can be a powerful tool to access the powerful database system that is Oracle. O'Reilly's SQL*Plus Pocket Reference puts a concise summary of this tool's capabilities at your fingertips.

If you're an occasional SQL*Plus user, this book will introduce you to a host of capabilities that you never knew were available from SQL*Plus. If you're a seasoned DBA and a command-line junkie like myself, the SQL*Plus pocket reference will likely become that little book that you always reach for when trying to remember just how to get that query result looking like you want it.

The bulk of the book is a command reference providing brief descriptions of each command available in SQL*Plus (with coverage including Oracle 8i). Also included is a reference of command-line arguments and environment settings. The book covers the tuning facilities available via SQL*Plus, as well as data and report formatting. And above and beyond the reference material in the book, numerous helpful examples of usage are also provided.

In summary, if you're planning on regular use of SQL*Plus, this book is essential. If you're new to SQL*Plus, a browse through the book will very likely open up to you a new world of just what you can do with SQL*Plus.

My rating: 9.5/10

I discount .5 for no index, which is about the only negative thing about the book. Yes, I know it's a pocket reference - but some of the pocket references do have indexes, and a good index makes any reference that much easier to use.
© 2002, Daniel C. Hanks.
Happiness
True love begins when the needs of others become more important than your own.
The practice of true love begets true happiness

Me

Daniel Hanks

I'm a system administrator working for Omniture

Interested in

perl
books
python
databases
genealogy
astronomy
digital archival
digital libraries
web applications
web infrastructure
distributed storage

among other things . . .

Storyteller


Pamela Hanks

is an excellent storyteller.

(She also happens to be my wife :-)

A storyteller makes a wonderful and unique addition to family, school, church or other group events. Schedule her for your next gathering.


Kiva.org
Kiva - loans that change lives

Recent Blog Entries

Subscribe with Bloglines
- OpenWest Conference 2014 Presentation Slides - Ansible
- OpenWest Conference 2013 Presentation Slides
- Utah Open Source Conference 2012 - Presentation slides
- E-Book Review: Data Mashups in R
- Book Review: Illustrated Guide to Astronomical Wonders
- Book Review: Wicked Cool Shell Scripts
- PLUG Presentation Slides: The Open Source Data Center
- Harnessing human computational power from computer games
- I love a good roadtrip
- FamilySearch Developers Conference 2008 presentations now available online
- FHT follow up: an idea for a mobile genealogical application
- Family history and technology: it's only getting better
- President Hinckley passes away
- December is NaBoMoReMo - National Book of Mormon Reading Month
- Family History, Photos, Blogs, and Books
- The Compact Oxford English Dictionary
- 1830s English and the Book of Mormon
- Google adds My Library feature to Book Search
- Utah Open Source Conference
- Wiki diagrammer (Steal this idea!)

All Entries . . .

LDSOSS
LDS Open Source Software
A website discussing the use of Open-source software for applications useful to those sharing values of the Latter-day Saint (Mormon) faith.

© 2009, Daniel C. Hanks