Run multiple SQL scripts with oracle SQL developer

Question

Right now I'm dropping, creating and then running scripts for several database several times each day. It's getting a little tedious.

I've simple scripts from dropping and creating databases and additional scripts that writes data to the DBs.

I run these scripts through oracle SQL developer. Is there a way I can run all of these scripts at the same time. Like in a batch file or another tool? I.e

Drop existing DBs
Create DBs
Run scripts for DBs

Haven't been able to figure it out

Create a .sql file with all the script in the order you want, open the .sql file on the SQL Developer and hit on run button — Jonxag
– Jonxag, Commented Jan 20, 2023 at 20:43
Yes, Oracle's client tool for use with batch programs is SQL*Plus. Check it out. — Paul W
– Paul W, Commented Jan 20, 2023 at 23:45

Reza Davoudian · Accepted Answer · 2023-01-21 07:04:37Z

3

You can create a scheduled job in sql developer. See bellow steps to create a job:

1- From your connection in sql developer select scheduler. In right click select "New Job ...".

2- In opened window you should select "PL/SQL Block" for "Type of Job" then write a block just like I wrote in bellow picture. Then you should select "Repeating" and insert intervals and start and end dates:

3- Keep in the mind that "Enable" box should be checked.

4- click on "Apply". Your Job will be ran based on intervals and start date you inserted.

answered Jan 21, 2023 at 7:04

Reza Davoudian

1636 bronze badges

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

2 Comments

Reza Davoudian Over a year ago

A tip! You can create a procedure including all of your codes, for example "Prc_DCR", and as "Type of Job" /"Stored Procedure" select just "Prc_DCR".

Banjaxx Over a year ago

Thank you very much. I'll play around with this but looks like it's exactly what I need

Collectives™ on Stack Overflow

Run multiple SQL scripts with oracle SQL developer

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related