Unix Scripting for Oracle

Course Description

This course is full of tips and techniques for novice and experienced developers & DBAs looking to work effectively with Unix scripting in Oracle databases. Topics are supplemented with hands-on lab exercises.
2 days
Contact us for pricing


No specific pre-requisites but prior knowledge of Oracle is expected.

Course Content Overview

Oracle Scripting Techniques
Introduction to ‘vi’, Textpad, SQL*Plus, TOAD
Includes Tips and Techniques for the experienced, provides a working knowledge for those new to Unix

Introduction to shell programming
Discussion of the various Unix commands, where to find additional help, and shell programming structures such as parameter passing, environment settings, looping, and if-then-else.

Oracle SQL Reporting Techniques
SQL*Plus formatting commands are useful for creating a variety of character-mode and web-based reporting. A variety of formatting techniques will be introduced.

Oracle SQL creating SQL
SQL*Plus is also useful for creating SQL scripts. These techniques are useful to make sure scripts contain current information.

Oracle data-driven scripting techniques
SQL*Plus variable handling is also useful for creating SQL and shell scripts based on data within the database. These techniques can be used to automate many types of repetitive tasks.

Shell Techniques
Variable Handling
Builds on Day 1 SQL*Plus scripts to provide Oracle Monitoring
Includes Paging, and Utility scripting techniques

Unix Shell Scripting meets Oracle RDBMS
Mixing Unix and Oracle commands for unique results
Integrates Day 1 SQL*Plus scripts into Unix shell scripts for better control, error handling, etc.
Illustrates how to check Oracle tasks for success or failure
Using Unix Cron to schedule these Oracle scripts

About Dan Hotka

Dan Hotka is a Training Specialist and an Oracle ACE Director Alumni (a recognized outside expert/evangelist on Oracle Products) who has over 39 years in the computer industry, over 33 years of experience with Oracle products. His experience with the Oracle RDBMS dates back to the Oracle V4.0 days. Dan enjoys sharing his knowledge of the Oracle RDBMS. Dan is well published with 14 Oracle books and well over 200 published articles. He is frequently published in Oracle trade journals, regularly blogs, and speaks at Oracle conferences and user groups around the world.
Dan is available for training in Ireland exclusively through Professional Training.

OracleOracle12cDan HotkaShell ScriptingUnix Shell ScriptingUnix ScriptingSQL PlusSQL*PlusTOADUnix