Enter value for xyz
Sometimes, when executing an SQL script in SQL*Plus, the message Enter value for xyz
show up:
SQL> @update-customers.sql
Enter value for xyz:
The cause for this message is (probably) that the script contains substitution variables and SQL*Plus prompts for the value that should be assigned to such a variable.
In order to turn off this message, use
set define off
Prevent displaying of commands found and executed in an SQL script file
With
echo
being set to
on
,
SQL*Plus will display (replicate) each command found within the SQL script before executing it.
I find this behavior in most cases quite distractful, therefor, I like to set it off:
SQL> set echo off
SQL> @script.sql