Rogue Security Wiki

Procedure for opening and running SQL scripts in Oracle SQL Developer.

  1. Open SQL Developer.
  2. In the Connections pane on the left, click on your SQL database connection.
    h2rssqldev_1.png
  3. Click File in the top-left corner.
    h2rssqldev_2.png
  4. In the dropdown menu, click Open.
    h2rssqldev_3.png
  5. In the Open window, browse to your SQL script.
    h2rssqldev_4.png
  6. Click Open. Your script will now appear in the editor.
  7. Click the Run Script button (next to the green play arrow).
    h2rssqldev_5.png
  8. Select the connection on which you want to run the script, then click OK.
    h2rssqldev_6.png
  9. The script output will be displayed in the Script Output pane at the bottom.
    h2rssqldev_7.png

✅ You have now successfully run a SQL script in SQL Developer.