... employee when i enter the employee_ID and tax rate as paraMETERS ?
IN PLSQL
Answers (1)
CREATE OR REPLACE PROCEDURE sal_tax(id VARCHAR, taxrate NUMBER) AS
saltax number;
BEGIN
SELECT salary FROM employee WHERE eid=id;
//Operation to calculate sal tax...
DBMS_OUTPUT.PUT_LINE(/*Your output statement here*/);
END;
/
To execute:
exec sal_tax(4, 98)
Hope this helps. If any query do ask.. :)
Good Day...