Search notes:

SQLcl: ARGUMENT

ARG[UMENT] argno {prompt|default} action-value [COMMENT comment]
The argument command is neat, but in the beginning of the year 2024, it is still impossible to create script-local named variables.

Highlighting the name of an executed script

The following simple SQL script uses the prompt command to color the name of another SQL script to be executed in green and then executes it. 
argument 1 prompt "script name"
prompt Running script @|green,intensity_bold &1|@
@ &1
Compare this «solution» with using script handlers to highlight executed scripts.

See also

parameterpolicy

Index