Hi,
I have a table 'TEMP' with 2 columns:
status char1
long_text long;

I have a another table TEMP1 exactly same as temp;
TEMP1 :

status char1
long_text long;


Problem is :
I have to write a trigger on TEMP ie,.
when ever status changes from 'Y' to 'N' then

I have to copy long_text(data of temp) into long_text column of TEMP1;

I tried various options but in vain;

Can you please help me

Badrinath