I need to perform this update on a base table in application that should not be altered. Can you guys please help me in this through PL/SQL procedure as I am not much experienced on that. 1 declare 2 v1 varchar2(500); 3 begin 4 select field1 into v1 from long_test; 5 dbms_output.put_line(v1); 6 update long_test set field2 = v1; 7* end; SQL> /" id="ctl00_m_m_i_ctl00_gr_ctl11_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5020855" / Select the long data into a variable. This worked fine for me to the records having length up to 4000. Can anyone please help me out as its an urgent requirement.....thanks in advance." id="ctl00_m_m_i_ctl00_gr_ctl13_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5023089" / Hi All, With all of your valuable suggestions, i had came to an approach but got hanged in the middle. Created a temporary table for the table that i want to update. converted the column in temporary table having long data type to CLOB. Applied the REPLACE operation which i want to perform on that temporary table. Updated contents in main table with contents from temporary table. ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual: 4790, maximum: 4000) The other hard part is that main table can't be done any alteration.This worked fine for me to the records having length up to 4000. Can anyone please help me out as its an urgent requirement.....thanks in advance.Can you guys please help me in this through PL/SQL procedure as I am not much experienced on that.

select * from t_u; A B C - - - 1 2 3 select * from t; A B - - 1 2 select * from u; A C - - 1 3 i didn't get answer to my question clearly....i what is that if i update a table in which the salary of an employee is updated than simultaneously the dept of employee should change to some other dept.

I need to update a long column as per a requirement. say 'ABCD') in values present in LONG column with an other code (for eg. For the columns other than LONG, i can able to achieve by REPLACE function but in case of LONG column, it's throwing error. Don" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5020160" / INSERT INTO nnn VALUES ('text ABC end'); commit; SELECT * FROM nnn; UPDATE nnn SET c1=REPLACE(c1,' ABC',' XYZ'); commit; SELECT * FROM nnn; drop table nnn;" id="ctl00_m_m_i_ctl00_gr_ctl03_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="5020234" / You need to use a procedure to select the data from the column into a variable that has a varhar2 data type.

Otherwise you will have to construct a PL/SQL script to use the replace.

I am also doing the same thing with the NEW_COUNT and OLD_COUNT...

Doing a 'join update' in Oracle can sometime cause a few headaches.