Easy Learning... (Web Development,.NET Technology,Oracle,Silverlight,REST,SQL,Oracle,MySQL,Data Science, Python and many more ...)
CREATE OR REPLACE PACKAGE BODY emp_sal AS
PROCEDURE find_sal(veno emp.eno%TYPE) IS
vesalary emp.esalary%TYPE;
BEGIN
SELECT esalary INTO vesalary
FROM emp
WHERE eno = veno;
dbms_output.put_line('Salary: '|| vesalary);
END;
END emp_sal;
/
Thanks for showing your interestI will shortly get back to you
No comments:
Post a Comment
Thanks for showing your interest
I will shortly get back to you