Appending to a long column

[tamilselvan]

create table xxx ( empno number , name_long long);

insert into xxx values (1, 'Tamil');
insert into xxx values (2, 'Kannan');
commit;

create or replace procedure yyy as
pname long;
cursor c1 is select empno, name_long from xxx;
begin
for c1_rec in c1 loop
pname := c1_rec.name_long||' Selvan';
update xxx set name_long = pname where empno = c1_rec.empno;
commit;
end loop;
end;
/

I hope the above example will help you.