Analyst2004
Technical User
A very basic question about SQL , about Temporary Substitution Variable that is '&' Ampersand
Whenever I use '&' to accept input from user before running a sql statement,
I get a standard prompt. See Eg. below.
SQL> Select * from Emp where empno = '&eno' ;
'Enter value for eno:'
Is there are way of customizing this prompt. Are there any environmental settings that will help me change this
standard prompt ? Any functions ? Commands ?
I know there is a 'PROMPT' command, but I am just using a SQL statement and not a script.
I am trying to spool the output from the statements where this "standard" message is on the first line, I would like to change it
to make it more meaningful.
Any suggestions ??
Whenever I use '&' to accept input from user before running a sql statement,
I get a standard prompt. See Eg. below.
SQL> Select * from Emp where empno = '&eno' ;
'Enter value for eno:'
Is there are way of customizing this prompt. Are there any environmental settings that will help me change this
standard prompt ? Any functions ? Commands ?
I know there is a 'PROMPT' command, but I am just using a SQL statement and not a script.
I am trying to spool the output from the statements where this "standard" message is on the first line, I would like to change it
to make it more meaningful.
Any suggestions ??