Oracle, how to make A list of updates for another column in A table with the name date date of B in the table has A name but A name in the table B in the table name is A one-to-many relationship
How do I link update

Two tables directly for update
The select a.n ame, a.A DMISSIONNO, b.n ame, b.z yh from drgs_basy a, testbak b where a.n ame=b.n ame and DISCHARGEDATE between to_date (' 2018-05-01 00:00:00 ', '- dd yyyy - mm hh24: mi: ss')
And to_date (' 23:59:59 2018-05-31 ', '- dd yyyy - mm hh24: mi: ss') for update

How to write an update statement

Wrote a few update statement is an error

CodePudding user response:

Data is what kind of, you want to, what is the result of the use of Excel a simple picture,

CodePudding user response:

For update of the query table is not allowed to update,
And you're updating A or B you didn't say these