Micro store procedure to modify or alter the course content based on title

course_content_replace.sql

begin
    for uu in (
        select pk1, title, main_data from course_contents where title like 'Title comes here%'
        and 
        crsmain_pk1 in (select pk1 from course_main where course_id in 
            (<course_id>)))
    loop
        update course_contents 
        set main_data = '<p>paragraph or list or whatever you want to place here</p>'
        where pk1 = uu.pk1;
        --used for debug
	--dbms_output.put_line('title' || uu.title);
    end loop;
end;