PL SQL Select Update
This is PL SQL Select Update
declare
cursor c1 is
select course_no,course_name,faculty
from coursemain;
rec c1%rowtype;
begin
for rec in c1 loop
update coursemain
Set course_name = rec.course_name,
faculty_no = rec.faculty
where course_no = rec.course_no;
end loop;
end;