Hi friends,
I'm trying to update a table j_edit with the values in the table below
Create table j_edit (
edit_key number(10),
edit_no number(9),
edit_id number(9),
median varchar2(5),
series_yn varchar2(1),
unit varchar2(20),
edit_date date,
description varchar2(100)
);
Columns to update in j_edit | Median = SPOR AND series_yn = Y | Median = NOTA OR series_yn <> Y | Median = DBN | Median = ENDO |
|
EDIT_KEY | 974 | 963 | 923 | 910 |
EDIT_NO | 435 | 121 | 891 | 9912 |
EDIT_ID | 600 | 600 | 601 | 603 |
UNIT | SEL | JLP | YNP | SEL |
EDIT_DATE | 31-Dec-2011 | 11-Aug-2016 | 15-May-2013 | 15-May-2013 |
Update j_edit table with the values above,
- Where j_edit.goc=’SEL’ AND
- Where median=’SPOR’ and series_yn=’Y’
- Where median=’NOTA’ or series_yn <> ‘Y’
- Where median =’DBN’
- Where median=’ENDO’
I can do Four different update SQL's for each where clause above, but is it possible to do this in a single update SQL? To update multiple fields with multiple where clauses in a single update statement? Please help.. Thanks a lot for your help