Toad World

Toad for Oracle Apps

Avatar photo
Post author:Written By

The following Toad for Oracle Apps are available for download as examples/samples.  Click on the App name to download an App.

App Description
Verify Server is Up This Toad App pings a server and sends a message stating whether the PING operation succeeds or fails. This is a simple illustration of If..Then..Else logic in Apps.
Select SQL Example This Toad App will execute a sample SELECT SQL statement.
Run a DB Health Check This Toad App will run a DB Health check on Oracle instance ORCL.
Output SCOTT Schema to HTML Document This Toad App will create an HTML Schema Document for the SCOTT schema.
Multiple Script Execution and Email Recipients This Toad App will execute multiple scripts and email the results to your recipient list.
Move Data Via Excel Export and Import This Toad application creates a copy table, loads the data by doing an Excel export from the original table, and then executes an Excel import. It also creates/updates a ZIP file that contains a running log of all of my excel files, and then sends an email with the report file attached to the recipients that need it. If a problem occurs, then I have an email notification sent to the creator of the report (me) and another sent to the recipient letting them know there is a problem and we are working on it.
Import SCOTT.DEPT from Excel This Toad App will import SCOTT.DEPT table data from an Excel spreadsheet in c:\temp to an Oracle table.
Export SCOTT.DEPT to Excel This Toad App will export all SCOTT.DEPT table data to an Excel spreadsheet in c:\temp.
Export DDL Example This Toad App exports all table DDL for SCOTT tables.
Developer DEMO This Toad App demonstrates how to use conditional logic (IF..THEN..ELSE) to group multiple Toad Apps.  This demo:

  1. Pings server to see if up
  2. If so, performs a Schema Compare between Prod and Dev
  3. Creates separate DDL files for a group of tables
  4. Zips the files into an archive
  5. Exports the data from one table to Excel
  6. Sends an email to a recipient with Zip and Excel files attached

 
 DBA DEMO This Toad App demonstrates how to use conditional logic (IF..THEN..ELSE) to group multiple Toad Apps.  This demo:

  1. Pings server to see if up
  2. Creates a single DDL file for a group of tables
  3. Creates an HTML schema report for 2 schemas
  4. Creates a tablespace script
  5. Defines a user list with multiple recipients
  6. Sends an email to users on the User List with 2 attachments

 
Database Object Search This Toad App will search the database for all SCOTT objects. 
Copy and Format Files This Toad App:

  1. Creates two directories in c:\temp
  2. Creates a poorly formatted SQL statement in c:\temp\PreSQL
  3. Copies file from b to c:\temp\PostSQL
  4. Runs the copied file through Toad's Formatter
  5. Renames the formatted file (There is another if..then..else condition that checks to see if the renamed file exists and deletes it if it does exist.)
  6. Pops up a message stating whether the process has succeeded or failed

This App serves as an example of more complex logic within an App and takes a somewhat interactive approach in terms of messaging.
Compare Two Schemas This Toad App will compare two schemas, in this case SCOTT and another SCOTT. 
Tags: ,