SQL> CREATE TABLE Test_json
  2  (
  3      ID      NUMBER (22),
  4      TYPE    NUMBER (22),
  5      NAME    VARCHAR2 (100)
  6  );

Table created.

SQL>
SQL>
SQL> CREATE OR REPLACE TYPE T_Test_json AS OBJECT
  2  (
  3      ID NUMBER (22),
  4      TYPE NUMBER (22),
  5      NAME VARCHAR2 (100)
  6  );
  7  /

Type created.

SQL>
SQL> create or replace view test_json_view of t_test_json
  2    with object identifier (id) as
  3  select *
  4    from test_json;

View created.

SQL>
SQL> insert into Test_json_view
  2  select js
  3      from (SELECT JSON_value('{"ID":-1,"TYPE":3,"NAME":"jsontest"}', '$' RETURNING T_Test_json) AS js
  4              FROM DUAL
  5              )
  6  /

1 row created.

SQL>
SQL> select *
  2    from test_json;

        ID       TYPE NAME
---------- ---------- ----------
        -1          3 jsontest