Jun 8, 2018 11:23:59 AM by Quest Software
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:
|
DBA DEMO | This Toad App demonstrates how to use conditional logic (IF..THEN..ELSE) to group multiple Toad Apps. This demo:
|
Database Object Search | This Toad App will search the database for all SCOTT objects. |
Copy and Format Files | This Toad App:
|
Compare Two Schemas | This Toad App will compare two schemas, in this case SCOTT and another SCOTT. |
Tags: Toad for Oracle Samples
Written by Quest Software
We use cookies to improve your experience with our site. By continuing to use this site, you consent to our use of cookies. Learn more.