Product Training 

Verify Server is Up

2 Jan 2013 at 6:36pm
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.
1504 0 /

Select SQL Example

2 Jan 2013 at 6:35pm
This Toad App will execute a sample SELECT SQL statement.
2019 0 /

Run a DB Health Check

2 Jan 2013 at 6:34pm
This Toad App will run a DB Health check on Oracle instance ORCL.
1366 0 /

Output SCOTT Schema to HTML Document

2 Jan 2013 at 6:33pm
This Toad App will create an HTML Schema Document for the SCOTT schema.
1412 0 /

Multiple Script Execution and Email Recipients

2 Jan 2013 at 6:32pm
This Toad App will execute multiple scripts and email the results to your recipient list.
1393 0 /

Move Data Via Excel Export and Import

2 Jan 2013 at 6:31pm
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...
1374 0 /

Import SCOTT.DEPT from Excel

2 Jan 2013 at 6:29pm
This Toad App will import SCOTT.DEPT table data from an Excel spreadsheet in c:\temp to an Oracle table.
1258 0 /

Export SCOTT.DEPT to Excel

2 Jan 2013 at 6:28pm
This Toad App will export all SCOTT.DEPT table data to an Excel spreadsheet in c:\temp.
1094 0 /

Export DDL Example

2 Jan 2013 at 6:27pm
This Toad App exports all table DDL for SCOTT tables.
1372 0 /

Developer DEMO

2 Jan 2013 at 6:26pm
This Toad App demonstrates how to use conditional logic (IF..THEN..ELSE) to group multiple Toad Apps. This demo: Pings server to see if up If so, performs a Schema Compare between Prod and Dev Creates separate DDL files for a group of tables Zips the...
1478 0 /

DBA DEMO

2 Jan 2013 at 6:25pm
This Toad App demonstrates how to use conditional logic (IF..THEN..ELSE) to group multiple Toad Apps. This demo: Pings server to see if up Creates a single DDL file for a group of tables Creates an HTML schema report for 2 schemas Creates a tablespace...
1196 0 /

Database Object Search

2 Jan 2013 at 6:24pm
This Toad App will search the database for all SCOTT objects.
1315 0 /

Copy and Format Files

2 Jan 2013 at 6:22pm
This Toad App: Creates two directories in c:\temp Creates a poorly formatted SQL statement in c:\temp\PreSQL Copies file from b to c:\temp\PostSQL Runs the copied file through Toad's Formatter Renames the formatted file (There...
1846 0 /

Compare Two Schemas

2 Jan 2013 at 6:20pm
This Toad App will compare two schemas, in this case SCOTT and another SCOTT.
2478 0 /