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

You can use "create database link" function:

          CREATE DATABASE LINK linkDB_1
            CONNECT TO xxxx IDENTIFIED BY xxxx
            USING 'xxxxx';


            SELECT *
            FROM   tablename@linkDB_1;

            DROP DATABASE LINK linkdb_1;

I tested on my SQL Navigator, and it works.

You can use JetBrains products like Intellij IDEA or DataGrip Prerequisites: -Ensure you have IntelliJ IDEA or DataGrip installed and configured with the necessary database drivers. Steps:

1. Establish Database Connections: -Open the Database tool window (View > Tool Windows > Database). -Click the "Add New" (+) icon and select "Data Source". -Choose your database type (e.g., MySQL, PostgreSQL, Oracle) and provide the required connection details (hostname, port, username, password, etc.). -Repeat this process for each database you intend to target.
2. Create a Database Script Run Configuration: -Go to the menu bar and select Run > Edit Configurations (or Run > Run Configurations... depending on your IntelliJ IDEA version). -Click the "Add New Configuration" (+) icon and choose "Database Script". -Assign a descriptive name to your configuration (e.g., "Multi-Database Script Execution").
3. Specify Target Data Sources: -In the "Target Data Source/Schema" section, click the "Add..." button. -Select the database connections you want to include from the list. You can select multiple connections simultaneously.
4. Select or Write Your SQL Script: -Execute Box: If you have a short, self-contained SQL statement, paste it directly into the "Execute" box within the configuration. -SQL File: For more complex scripts, navigate to the file containing your SQL code in the Project tool window. Drag and drop the file onto the appropriate data source/schema in the configuration.
5. Execute the Script: -Back in the Run Configurations window, click the "Run" button (or the green play icon) to initiate the script execution across all chosen databases.