create table student_details( roll int, marks int, phone int, primary key(roll)); insert into student_details values(2,50,12345); insert into student_details values(3,60,67894); insert into student_details values(4,70,12345); create or replace procedure pr1 as begin update student_details set marks=marks+(marks*0.05); end; begin execute pr1; end; select * from student_details;