User needs to give employee_id to fetch the data.
The above query will ask input for Employee_id in box format. Select employee_id,First_name,job_id from Employees where employee_id=&Emp_no If you want to execute the following statement using substitution variable Real life example for HR schema on Oracle developer
You can use substitution variable in select statement, order by clause or where condition. If we require to check the results if any issues in select statement for the application, we need to use the substitution variable. & substitution variable & Substitution Variables : There are two types of substitution variables. The substitution variables are temporary variables using which user give the input conditions for select statements.
The substitution variables are nothing but temporary variables which is used for reusability purpose. This will give you clear idea about substitution variables in oracle and how you can use the substitution variable in detail. In this article I would like to throw light on substitution variables with real life examples.
#PL SQL PROMPT FOR INPUT HOW TO#
In my previous article I have explained how to prepare for OCA with simple select statements examples.
0 kommentar(er)
