Written by a distinguished graduate of West Point, Col. Garmany
leverages his 20+ years of experience into
an indispensable guide for any Oracle professional who must
quickly implement Oracle reporting. A
noted instructor, author and lecturer, Col. John Garmany leverages
his ability to explain complex issues in Plain English into a
one-of-a-kind book. John Garmany targets his
decades of SQL*Plus experience into this must-have book. Intended for
anyone who need to extract Oracle data and format reports, John reveals the secrets of quickly and easily producing
stunning reports from Oracle.
Unknown to most Oracle
professionals, special SQL extraction techniques and SQL*Plus
commands can be used to quickly create complex reports, without
buying expensive third-party reporting tools. Best of all,
Colonel Garmany shares dozens of working samples in his online code
depot. Your time savings from a single script is worth the price
of this great book.
Shows secrets for quickly creating
and printing reports from Oracle data.
Comes with an online code deport
with working examples of Oracle reports.
Describes the use of all SQL*Plus
commands including column heading, column format, compute and
Shows how to incorporate Oracle8i
analytic functions in Oracle reports
Contains working SQL*Plus scripts
to get you started fast.
- Presents tricks
for writing complex SQL in incremental stages.
Table of Contents:
Chapter 1: Using SQL*Plus and
Chapter 2: Incremental approach to
Chapter 3: Writing the SQL.
Chapter 4: Spooling and viewing
Chapter 5: Formatting data.
Creating summaries and breaks.
About the Author:
||Colonel John Garmany is a graduate of
West Point, an Airborne Ranger and a retired Lt. Colonel with
20+ years of IT experience. John is an OCP Certified Oracle
DBA with a Master Degree in Information Systems, a Graduate
Certificate in Software Engineering, and a BS degree
(Electrical Engineering) from West Point. A respected Oracle
expert and author, John serves as a writer for
DBAZine and Builder.com.
John is the author of "Logical Database
Design - Principles & Practices" by CRC Press, the
"Oracle9iAS Administration Handbook" by Oracle Press and "Oracle
Snapshot, Multi-master & Materialized Views Scripts" and "Oracle SQL*Plus Reports
Fast reporting with SQL and SQL*Plus" by Rampant TechPress.