SQL* Plus support

SqlDbx currently does not support SQL*Plus commands. The only supported commands is VARIABLE and DEFINE, all others ignored. You still can execute SQL*Plus scripts but it is possible you will get errors in certain situations. For example if scripts prompts for variable value using &&name method. Support for some SQL*Plus commands is planned for future release of SqlDbx.

You can use "/" as a command separator. Typing / will not run the content of the buffer but will serve as batch separator when you execute part or the whole script.

SqlDbx can generate SQL*Plus compatible scripts. This option can be enabled in Tools->Options->Servers->Oracle->SQL*Plus Compatible Scripting

Supported SQL*Plus functionality:

SqlDbx supports SQL*Plus substitution variables with some minor differences. For details of how to use substitution variables click here Script Variables