Tuesday, June 19, 2018

Create a Procedure that update the salary of employee using following formula Sal+(percentage/100) pass two parameter value : Name & Percentage. Table : Salary - DBMS (Procedure)

create or replace procedure upd(name1 in varchar2,per in number) is
begin
update salary set salary=salary+(salary*(per/100)) where Name=name1;
end;

No comments:

Post a Comment