Oracle SQL*Plus : The Definitive Guide, 2nd Edition

Rating:
Summary: great guide
Review: I have found this book to be a really great guide that is easy to follow. The author provides a gentle, but thorough introduction to topics like creating reports, writing scripts, customization etc. He offers methodologies and alternatives beyond the syntax that you can find in the manual. For example, he presents and evaluates six ways one can achieve some kind of if-then-else flow control in SQL*Plus.

[...]

Rating:
Summary: the glories of the command line
Review: The glories of the command line. SQLPlus [I am not going to write that irritating asterix] is an acknowledgment of the reality that for many large computer programs and operating systems, a command line utility is vital. The book explains this for the specific instance of hooking to Oracle's database. It is meant as a definitive reference. Showing every command, often accompanied by example code.

For an Oracle DBA, a good acquaintance with SQLPlus is probably mandatory. From the book, you can see how to quickly interrogate the database and get results in various useful paginated formats. Plus, and vitally, you can see how to build script files that can be run, where these files encode your experience in amassing customised sequences of commands specific to your needs. Exactly analogous to batch files in most operating systems, and just as useful.

Along those lines, SQLPlus is conceptually not that hard. When using Oracle, it is often far more important, and harder, to design optimal tables for a given problem.