Code Snippet posted by:
Bubbly | Posted on: 2/28/2010 | Category:
Others Codes | Views: 1721 | Status:
[Member]
|
Alert Moderator
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.
++
Thanks & Regards,
Deepika