& Substitution variable in Oracle

Posted by Bubbly under Others category on | Views : 2774
Use ampersand (&) substitute variable to prompt user for a input value.

SELECT empid,firstname, lastname, jobcode, salary FROM Employee WHERE empid = &employeeid;

This will prompt user for input in iSQL * Plus for employeeid and then when you click on submit for execution it will display the result.

Comments or Responses

Login to post response