SELECT SALARY FROM EMP_DETAILS_VIEW WHERE EMPLOYEE_ID='&X.5' If you wish to append characters immediately after a substitution variable, use a period to separate the variable from the character. Name can be entered each time the script is run.

If these two commands are stored in a SQL*Plus script, a different last SQL> select employee_id from employees where last_name = '&myv' SQL*Plus displays the following output: JOB_ID MAXIMUMДЄ more practical use of substitution variables is to prompt for a valueД«efore referencing the variable: SQL> accept myv char prompt 'Enter a last name: ' Now run the script STATS: respond to the prompts for values as shown: Enter value for group_col: JOB_ID You can suppress this listing by setting the SET command variable VERIFY to OFF. SQL*Plus reads your response from the keyboard or standard input.ДЄfter you enter a value at the prompt, SQL*Plus lists the line containing the substitution variable twice: once before substituting the value you enter and once after substitution. If the SQL command containing the reference should have quote marks around the variable and you do not include them there, the user must include the quotes when prompted. You can enter any string at the prompt, even one containing blanks and punctuation. When SQL*Plus encounters an undefined substitution variable in a command, SQL*Plus prompts you for the value. You can use substitution variables anywhere in SQL and SQL*Plus commands, except as the first word entered.

Dbschema no more spool space