By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE employee
(
ID INTEGER PRIMARY KEY,
NAME VARCHAR2(100),
DATEOFBIRTH DATE,
STARTYEAR CHAR(4),
ENDYEAR CHAR(4),
COMPANY VARCHAR2(100)
);
INSERT INTO employee VALUES (1, 'Tim', TO_DATE('07/04/1994', 'MM/DD/YYYY'), 2020, 2021, 'ABC Co');
1 rows affected
SELECT *
FROM employee;
| ID | NAME | DATEOFBIRTH | STARTYEAR | ENDYEAR | COMPANY |
|---|---|---|---|---|---|
| 1 | Tim | 04-JUL-94 | 2020 | 2021 | ABC Co |
UPDATE employee e
SET (name, dateofbirth, startyear, endyear, company) =
(SELECT NVL(j.name, e.name), NVL(j.dateofBirth, e.dateofBirth),
NVL(j.startyear, e.startyear), NVL(j.endyear, e.endyear),
NVL(j.company, e.company)
FROM JSON_TABLE('{"name":"Jim"}'
COLUMNS(name, dateOfBirth DATE, startyear, endyear, company)) j)
WHERE e.id = 1;
1 rows affected
SELECT *
FROM employee;
| ID | NAME | DATEOFBIRTH | STARTYEAR | ENDYEAR | COMPANY |
|---|---|---|---|---|---|
| 1 | Jim | 04-JUL-94 | 2020 | 2021 | ABC Co |