Press "Enter" to skip to content

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:

Have you found the answer to your question? If not, you can discuss it with me in the comments section below or join my Q&A community OrclQA.com for developers and ask your question. It is FREE.

Vinish Kapoor

Follow

Hi, I am a full stack developer and writing about development. I document everything I learn and help thousands of people. foxinfotech.in is created, written, and maintained by me; it is built on WordPress, and hosted by Bluehost. Connect with me on Facebook, Twitter, GitHub, and get notifications for new posts.

guest
0 Comments
Inline Feedbacks
View all comments