REVIEW - Oracle SQL*Plus


Title:

Oracle SQL*Plus

Author:

Jonathan Gennick

ISBN:

Publisher:

O'Reilly (1999)

Pages:

502pp

Reviewer:

Dave Rutlidge

Reviewed:

December 1999

Rating:

★★★☆☆


At the price the book provides good value for money and is a useful addition to the bookshelf of even the more experienced Oracle user.

SQL*Plus is the ubiquitous command line user interface for all implementations of the Oracle database. It is a client-server application that enables users to enter and execute SQL statements and PL/SQL blocks and to run predefined SQL*Plus script files. These files can contain DDL, SQL, PL/SQL or even SQL*Plus commands.

This book sets out to thoroughly teach every aspect of SQL*Plus and to do so in a way that can be used as a tutorial or as a problem- solving 'how-to' type book. This is a very ambitious goal, but one that is largely achieved. One of the strengths of the book is that it organised such that each chapter aims to present a solution to a real-world problem. For example, one chapter is devoted to extracting and loading data, while another covers report generation.

Work-a-rounds for some of the limitations of SQL*Plus are presented in the chapter on advanced scripting, including, for example, six different ways of achieving branching within a script (even if one of them is to use shell script).

The reader is assumed to have a working knowledge of both SQL and PL/SQL and in some examples knowledge of packages such as DBMS_SQL - although the book does point the reader to the oracle documentation (and another O'Reilly book) in this instance.

The book is flagged as 'includes Oracle8i', but the use of Oracle 8 is not assumed and the reader is warned where there are significant differences between versions.

While there is no code disc accompanying the book, sample code and test data is available on the O'Reilly web site. While most Oracle users might have access to the web, it is unfortunate that there seems no other way of receiving the code and test data.

The book contains a comprehensive SQL*Plus reference in the appendices. It would have been really nice, in my opinion, if SQL and PL/SQL reference sections had also been included to provide more of a one-stop reference shop.

At the price the book provides good value for money and is a useful addition to the bookshelf of even the more experienced Oracle user.


Book cover image courtesy of Open Library.





Your Privacy

By clicking "Accept Non-Essential Cookies" you agree ACCU can store non-essential cookies on your device and disclose information in accordance with our Privacy Policy and Cookie Policy.

Current Setting: Non-Essential Cookies REJECTED


By clicking "Include Third Party Content" you agree ACCU can forward your IP address to third-party sites (such as YouTube) to enhance the information presented on this site, and that third-party sites may store cookies on your device.

Current Setting: Third Party Content EXCLUDED



Settings can be changed at any time from the Cookie Policy page.