How to Run SQL Script in Toad?

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:

• How to Insert Data in Table Using Toad?