Search code examples
sqloracle-databaseoracle-sqldeveloper

Run SQL script on multiple DB connections at same time in Oracle SQL Developer

I have 4 different database connections in Oracle SQL Developer. All of them have the exact same set of packages and procedures. Every time I change something in my scripts I have to run it on all of the connections one-by-one. Is there no way to run it on all the connections at the same time?

Solution

  • I'm afraid that you can only execute SQL developer queries on different connections using the GUI.

    You should, however, be able to acheive what you want using SQLPlus instead.