specifying variables at runtime
You can create a command file containing a WHERE clause to restrict the rows
displayed. To change the condition each time the command file is run, you use
substitution variables. Substitution variables can replace values in the WHERE
clause, a text string, and even a column or a table name.
At the end of this lesson, you should be able to
Create a SELECT statement that prompts the user to enter a value at runtime.
Use the SQL*Plus ACCEPT command to define a variable.
Define a variable that can be automatically picked up by the SELECT statement
at runtime....