Easy Oracle PL/SQL Programming

Written by a distinguished graduate of West Point,  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, 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.

Easy Oracle PL/SQL provides you with the tools you need to create, debug and execute PL/SQL code. The example driven methodology will have you coding basic PL/SQL blocks by the end of the first chapter. Each chapter will build on previous concepts, introducing you to increasingly more complex PL/SQL coding, while always focusing on readability and manageability.

Each concept is introduced using multiple examples and each chapter has exercises to test you knowledge. With Easy Oracle PL/SQL you will be able to put the incredible power of the Oracle Database to use with your application.

Easy HTML-DB Oracle Application Express

Oracle Application Express (Apex, formerly called HTML DB) is one of the most exciting web application development tools on the market and this is the first and best HTML-DB Application express book. HTML-DB Application Express is a true Rapid Application Development environment that can take an idea from concept to a working production level application in a very short period of time and this book can help.

This unique book provides easy step-by-step examples to guide you through the various features and removes the guesswork from learning Oracle HTML DB Application Express. This book describes the techniques necessary to build Easy HTML DB Apex applications, and shows working examples of HTML DB database access from the simple web page population to the complex database transaction enforcing multi-user concurrency.

This book is unique because it describes all HTML DB Application Express concepts in an easy to understand language and contains step-by-step working examples of various HTML DB features. The HTML-DB Application Express book shows the when, where, why, and how of using each feature to build and deploy your web applications. It is designed for any Oracle professional including DBA's, application developers, Network Engineers and IT managers.

Oracle Job Scheduling

This unique book focuses on the use of internal utilities to schedule complex Oracle database tasks.  The book compares external job scheduling with UNIX cron and Windows AT command, and shows the differences between the dbms_job and dbms_scheduler utilities. 

This indispensable reference shows working examples of how to schedule complex time-based jobs, creating streams of multiple jobs, scheduling job streams with intermediate error checking, scheduling of event-based jobs, and much, much more.