I have a table with a LONG column that contains text over 4000 characters. This text is entered through a third party application so I cannot change the table structure. I want to append some text at the end of the existing data, how can I do that through PL/SQL or just plain SQL in SQLPlus. The Oracle version is 8.1.7 on Sun Solaris.
create table xxx ( empno number , name_long long);
insert into xxx values (1, 'Tamil');
insert into xxx values (2, 'Kannan');
create or replace procedure yyy as
cursor c1 is select empno, name_long from xxx;
for c1_rec in c1 loop
pname := c1_rec.name_long||' Selvan';
update xxx set name_long = pname where empno = c1_rec.empno;
I hope the above example will help you.
Click Here to Expand Forum to Full Width