Need an update statement for table for person_code column having 2 entries and EFFECT_FRM_DAT <> sysdate, It should update EFFECT_TO_DAT to sysdate -1 and corresponding column ‘FLG’ to ‘0’ .
sample person_Code with above condition are BAMAKEIR00,C701015413.

Data set sample

PERSON_CODE  EFFECT_FRM_DAT   EFFECT_TO_DAT   FLG CUST_SEGMENT
BAMAKEIR00  21-05-24    31-12-50    1   Active
BAMAKEIR00  29-01-24    31-12-50    1   Inactive
C169008236  20-03-24    31-12-50    1   Active
C213000740  10-04-24    31-12-50    1   Inactive
C318028421  22-01-24    31-12-50    1   Active
C342004503  29-01-24    31-12-50    1   Leads
C701015413  21-05-24    31-12-50    1   Defecting
C701015413  29-01-24    31-12-50    1   Inactive
T002273770  29-01-24    31-12-50    1   Active

Expected output

PERSON_CODE  EFFECT_FRM_DAT   EFFECT_TO_DAT   FLG CUST_SEGMENT
BAMAKEIR00  21-05-24    31-12-50    1   Active
BAMAKEIR00  29-01-24    20-05-24    0   Inactive
C169008236  20-03-24    31-12-50    1   Active
C213000740  10-04-24    31-12-50    1   Inactive
C318028421  22-01-24    31-12-50    1   Active
C342004503  29-01-24    31-12-50    1   Leads 
C701015413  21-05-24    31-12-50    1   Defecting
C701015413  29-01-24    20-05-24    0   Inactive
T002273770  29-01-24    31-12-50    1   Active