silent
public text v1 · immutableCREATE PROCEDURE UpdateEmployee
(empID employee.employeeID%TYPE, empSalary employee.employeeSalary%TYPE)
IS
BEGIN
UPDATE Employee set employeeSalary = empSalary where employeeID = empID;
END;
/CREATE PROCEDURE UpdateEmployee
(empID employee.employeeID%TYPE, empSalary employee.employeeSalary%TYPE)
IS
BEGIN
UPDATE Employee set employeeSalary = empSalary where employeeID = empID;
END;
/