Running the scripts using TOAD Through SQL*PLUS

Provide the Source Path and the Destination path and execute script from Editor > Execute as Script.

Enter User-Name and Password (E.g. SYSADM@FINC and Infor1) and ensure that the destination folder is created.

  • Example to run Oracle script using TOAD via SQL*PLUS

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

    Note: 

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

A command prompt window displays the status of the script.