Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Oracle update one table based on value in another - Can't get this right.
Business case: Table1 did not get updated by someone elses data load, so I have to fix it. (Yay!) Anyway, here is the case. Table1.hrc needs updated to match Table2.hrc with the following conditions: Table1.num = Table2.num and Table2.status = 'HOLD' and Table1.hrc is null and Table2.hrc is...- cjax920
- Thread
- Replies: 1
- Forum: Oracle: All versions
