How to Run SQL Script in Toad?

  • Post author:
  • Post category:Toad
  • Reading time:1 mins read

There are two ways to run an SQL script in Toad. The following are the examples.

Run SQL Script in Toad for Oracle

Method - 1

  1. Open Toad and connect to the database. Then click on the menu Database > SQL Editor.
  2. In SQL Editor, give the same command starting with @ as you use to give in SQL Plus to run an SQL script in Oracle. For example, @ D:\yourdir\example_script.sql and then press F5 to run the script.

Method - 2

  1. Open Toad and connect to the database. Then click on the menu Database > SQL Editor.
  2. In SQL Editor, press Ctrl+O and the open file dialog box will appear. Locate your SQL script and open.
  3. Then Press F5 or F9 to execute the SQL script contents.

See also:

Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.in and orclqa.com a question and answer forum for developers.