I'm trying to find a good alternative to SQL Developer for performing queries and scripts on Oracle instances.
I find ***DBeaver*** to be an interesting tool, it has a lot of great features, ***BUT*** it seems to lack an essential element: The possibility to launch scripts from the filesystem of the client machine in a batch-like way.
For example, in SQL Developer I simply put a file called *delta_script.sql* that contains:
@script1.sql
@script2.sql
@script3.sql
I execute it as a script and the software executes all of the files in the correct order (provided that they are in the same directory as the delta_script.sql file).
On DBeaver, this does not happen, instead I get a * **ORA-00900**: invalid SQL statement.*.
How can I manage this to work as expected?
I have tried the following in the delta_script.sql file with no luck:
- @@ scriptN.sql
- @/tmp/folder/scriptN.sql
- @"/tmp/folder/scriptN.sql"
- @"scriptN.sql"
They're all giving the same error, so I think there's a problem with the "@".
I have tried from SQLPlus with the synthax I use on SQL Developer without errors.
Asked by Samuryte
(111 rep)
Mar 3, 2016, 12:56 PM
Last activity: Oct 1, 2024, 05:56 PM
Last activity: Oct 1, 2024, 05:56 PM