Update Several Records of one table

Apr 12 2021 5:09 PM
Hi,
 
it´s pósible to use only one UDATE in this instruction, nota that we use only one TABLE
 
UPDATE COT_LINEADET SET LID_APORTE_INFORMADO = '21739', LID_DIF_APORTE = '0' WHERE PER_RUT = '26558114' AND LID_ULTFECACT between TO_DATE('31-03-2021 08:00:00', 'dd-mm-yyyy HH24:MI:SS') and TO_DATE('31-03-2021 10:00:00', 'dd-mm-yyyy HH24:MI:SS') AND LID_ULTUSUACT = 'OPS$JOLMEDO' ;
 
UPDATE COT_LINEADET SET LID_APORTE_INFORMADO = '10122', LID_DIF_APORTE = '0' WHERE PER_RUT = '13391016' AND LID_ULTFECACT between TO_DATE('31-03-2021 08:00:00', 'dd-mm-yyyy HH24:MI:SS') and TO_DATE('31-03-2021 10:00:00', 'dd-mm-yyyy HH24:MI:SS') AND LID_ULTUSUACT = 'OPS$JOLMEDO' ;
 
UPDATE COT_LINEADET SET LID_APORTE_INFORMADO = '24184', LID_DIF_APORTE = '0' WHERE PER_RUT = '7921736' AND LID_ULTFECACT between TO_DATE('31-03-2021 08:00:00', 'dd-mm-yyyy HH24:MI:SS') and TO_DATE('31-03-2021 10:00:00', 'dd-mm-yyyy HH24:MI:SS') AND LID_ULTUSUACT = 'OPS$JOLMEDO' ;
 
UPDATE COT_LINEADET SET LID_APORTE_INFORMADO = '24275', LID_DIF_APORTE = '0' WHERE PER_RUT = '7112295' AND LID_ULTFECACT between TO_DATE('31-03-2021 08:00:00', 'dd-mm-yyyy HH24:MI:SS') and TO_DATE('31-03-2021 10:00:00', 'dd-mm-yyyy HH24:MI:SS') AND LID_ULTUSUACT = 'OPS$JOLMEDO' ;
 
UPDATE COT_LINEADET SET LID_APORTE_INFORMADO = '0', LID_DIF_APORTE = '0' WHERE PER_RUT = '9697278' AND LID_ULTFECACT between TO_DATE('31-03-2021 08:00:00', 'dd-mm-yyyy HH24:MI:SS') and TO_DATE('31-03-2021 10:00:00', 'dd-mm-yyyy HH24:MI:SS') AND LID_ULTUSUACT = 'OPS$JOLMEDO' ;
UPDATE COT_LINEADET SET LID_APORTE_INFORMADO = '25478', LID_DIF_APORTE = '0' WHERE PER_RUT = '13326167' AND LID_ULTFECACT between TO_DATE('31-03-2021 08:00:00', 'dd-mm-yyyy HH24:MI:SS') and TO_DATE('31-03-2021 10:00:00', 'dd-mm-yyyy HH24:MI:SS') AND LID_ULTUSUACT = 'OPS$JOLMEDO' ;
 
 
Thank u out there. 
 

Answers (4)