Hello, because you are asking feedback for sql developer,
I decided to share the problem I had and caused not to use sql developer;
it is about the run of complex scripts:
-selects (this must show the result of the query)
-enable the stop of wrong statements, some times this is done to make some task, i.e. reconecting after crating a database trigger.
the problem if you run it in sqlplus, it don't stop, you don't have the chance to modify the script in the way, as in a notepad window.
Aditionally I would like scripting
This means a more advanced functioning of scripts, that can't be done in a begin end;
- a commant to reconnect
- a condition to validate and use variable as if all the script would be a being end, you define variables and use them.
- to save a query into a value (without having a declare function), like defining a dos, or a global variable
- i.e. stop the script (even if the stop on error is disabled), in example if a validation gives false,
there are more but I think you got the idea, and advanced runner of complex scripts.
have you seen the PAUSE command?
Displays the specified text, then waits for the user to press [Return].