How to Run SQL Script in Toad?

Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

November 17, 2023
Toad
2 mins read

Welcome to the world of Toad for Oracle, where unleashing the power of SQL scripts has never been easier. In this tutorial, we will guide you through the process of running SQL scripts using Toad for Oracle, a versatile and powerful database management tool.

Run SQL Script in Toad for Oracle

To run SQL scripts in Toad for Oracle, you have two methods at your disposal. Let us explore both of them:

Method - 1

Open Toad and connect to the database. Then click on the menu Database > SQL Editor.
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

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

Whichever method you choose, Toad for Oracle empowers you to effortlessly run SQL scripts, enabling seamless database management and unleashing your coding potential.