Code Genic is a blog which provides the codes for the daily life uses. All the codes are mostly for college related Projects or Lab work.
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;
No comments:
Post a Comment