Run multiple queries in SQL PLUS

Question

I am beginner at using SQL and I have searched a lot but couldn't solve that issue. I have about 2500 lines of queries and I need to run all these lines in one shot. When pasting those lines to SQL PLus editor it just executes about 75 lines and ignores the rest of lines Can you guide me please of how to do that? Thanks advanced for help

Thomas G · Accepted Answer · 2018-05-09 08:26:16Z

2

Put your SQL statement(s) in a script file and execute it

For instance : open notepad. Paste your SQL. Save the file on your desktop and name it test.sql

Then in SQL plus prompt, just do this :

SQL > @C:\Users\YourName\Desktop\test.sql

(the @ is the trick)

answered May 9, 2018 at 8:26

Thomas G

10.3k7 gold badges33 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

YasserKhalil Over a year ago

That's perfect. Thank you very much for great and awesome help

Collectives™ on Stack Overflow

Run multiple queries in SQL PLUS

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related