Running the scripts using TOAD through Toad Script Runner

Provide the Source Path and the Destination path and execute the script from Editor > Execute SQL via TSR.

• Example to run Oracle script using TOAD via Toad Script Runner

  @'C:\ORCLAI\ExtractORCLAI.SQL' 'C:\ORCLAISQLTSR' 'US' 'APPS' 'VIS' 'ENGLISH' 'US'

  Note: 

  C:\ORCLAI\ExtractORCLAI.SQL is the location of SQL script and C:\ORCLAI_SQLTSR is the location for extracted data.

A window is displayed. The upper part of the window displays the SQL query and the bottom part displays the status of the script that is running.