Does SQLDeveloper support executing scripts?

For each file you need to run, find it and drop it into SQLDeveloper. Run the script (F5) and then commit (F11). This will work for some scripts, but not all.

I was looking through the help files and found how to do it in SQL Developer Concepts and Usage->Using the SQL Worksheet->Script Runner.

Basically, you have to precede the file name with an @. For example @C:\MyScript\Script.sql.

You can then run a batch of them this way. Note that the command doesn't seem to like spaces in the file path.

SQL Developer these days comes with another tool called sqlcl. This is a bit like SQLPlus but is actually using some bits from SQL Developer to give a compatible command line/scripting type interface.

You would be able to use it to execute sqlplus style commands without fighting the extras of the SQL Developer style GUI which can get confusing.

Look for it under wherever SQL Developer is sitting. If you don't have it there, you can download it and deploy it into your sqldeveloper folder.

To run scripts in SQL Developer:

@"\Path\Scriptname.sql"

(You only need the quotes if there are any spaces)

You can set a default Path: Tools menu > Preferences > Database > Worksheet > Select default path to look for scripts