Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE employees
(
  EMPLOYEE_ID INTEGER PRIMARY KEY,
  SALARY INTEGER
);
INSERT INTO employees
SELECT *
FROM JSON_TABLE('{employees:[
                   {employee_id: 123, salary: 100000}, 
                   {employee_id: 234, salary: 90000}
                 ]}',
                '$.employees[*]'
                COLUMNS (employee_id NUMBER PATH '$.employee_id', 
                         salary NUMBER PATH '$.salary'));
2 rows affected

SELECT *
FROM employees;


EMPLOYEE_ID
SALARY


123
100000

234
90000