How to run .sql file in sql developer from the specified path

It should be working.

Version 17.2

Run with F5

The path shown in your File Explorer view is differnt and longer than the path used in sql develoepr

Your SQL Developer path is this:

@C:\SVNwc\idh2\crm\trunk\sql\3.6\Delete_F_ORDER_LINE.sql;

But should be this:

@C:\SVNwc\idh2\crm\trunk\sql\3.6\db_datavault\meta_app_idh\tables\Delete_F_ORDER_LINE.sql;

At least that is what file explorer is showing.

Jim

Using special characters in filenames is always going to be problematic.

As you have chosen to name the files with a trailing semicolon, you will need to put the path and filename in double quotes.

For example:

SQL> select 'daft filename using ";"' from dual;

 

'DAFTFILENAMEUSING";"'

-----------------------

daft filename using ";"

 

SQL> save "test.sql;"

Created file test.sql;

SQL> @test.sql;

SP2-0310: unable to open file "test.sql"

SQL> @"test.sql;"

 

'DAFTFILENAMEUSING";"'

-----------------------

daft filename using ";"

Here is the same file being run in SQL Developer:

Fail.

Using double quotes:

Success.