I have a table 'TEMP' with 2 columns:
I have a another table TEMP1 exactly same as temp;
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