TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ramón Miguel Quintana Rosa
1.7k
74
16.1k
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
C
OT_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.
Reply
Answers (
4
)
how to get the records greater than date in the oracle database
Need to update Table columns using View in Oracle