Blogs | Toad

Toad for Oracle Apps

Post author:Written By |
Toad for Oracle Apps

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

AppDescription
Verify Server is UpThis 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 ExampleThis Toad App will execute a sample SELECT SQL statement.
Run a DB Health CheckThis Toad App will run a DB Health check on Oracle instance ORCL.
Output SCOTT Schema to HTML DocumentThis Toad App will create an HTML Schema Document for the SCOTT schema.
Multiple Script Execution and Email RecipientsThis Toad App will execute multiple scripts and email the results to your recipient list.
Move Data Via Excel Export and ImportThis 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 ExcelThis Toad App will import SCOTT.DEPT table data from an Excel spreadsheet in c:\temp to an Oracle table.
Export SCOTT.DEPT to ExcelThis Toad App will export all SCOTT.DEPT table data to an Excel spreadsheet in c:\temp.
Export DDL ExampleThis Toad App exports all table DDL for SCOTT tables.
Developer DEMOThis 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 DEMOThis 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 SearchThis Toad App will search the database for all SCOTT objects. 
Copy and Format FilesThis 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 SchemasThis Toad App will compare two schemas, in this case SCOTT and another SCOTT. 
Tags: ,