Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UPDATE(minus)

JellyApr 24 2019 — edited Apr 24 2019

TABLE1

NAME   ID   DATE

A           1     2019-04-01

A           2      2019-04-02

B          1       2019-04-01

B          2       2019-04-01

select    ID ,DATE from  TABLE1   where NAME='A'

minus

select  ID ,DATE from TABLE1    where NAME='B'

I wish UPDATE B  same information(ID,DATE)

UPDATE SQL??

UPDATE  TABLE1 SET ........................................

WHERE NAME='B'

Comments
Post Details
Added on Apr 24 2019
2 comments
355 views