CLOB update

You must execute the code again to save those values in the database.

CREATE TABLE TEST_CLOB
  (	ID NUMBER(10,0), 
	IMPORTDATA CLOB
  );
  
insert into test_clob values (1001,'{"ClassId":30074,"Attributes":[{"Name":"ID","Value":"265794"},{"Name":"HREF","Value":"-1"},{"Name":"HPRECISION","Value":"5"},{"Name":"HMETHOD","Value":"96"},{"Name":"GEO-METHOD","Value":"96"},{"Name":"GEO-PRECISION","Value":"5"},{"Name":"GEO-VISIBILITY","Value":"0"},{"Name":"REMARK","Value":"-1"}]}');
insert into test_clob values (1002,'{"ClassId":30000,"Attributes":[{"Name":"ID","Value":"265756"},{"Name":"HREF","Value":"unknown"},{"Name":"HPRECISION","Value":"4"},{"Name":"HMETHOD","Value":"90"},{"Name":"GEO-METHOD","Value":"0"},{"Name":"GEO-PRECISION","Value":"1"},{"Name":"GEO-VISIBILITY","Value":"0"},{"Name":"REMARK","Value":"-1"}]}');
commit;
SELECT id,HMETHOD,HPRECISION, HREF
    FROM   (
      select id,
             name,
             value
      from   test_clob tt1
             CROSS APPLY JSON_TABLE
             (
               tt1.IMPORTDATA,
               '$'
               COLUMNS 
               (
                 classid NUMBER PATH '$.ClassId',
                 NESTED PATH '$.Attributes[*]' COLUMNS 
                 (
                   name  VARCHAR2(20) PATH '$.Name',
                   value VARCHAR2(20) PATH '$.Value'
                 )
               )
             ) 
    )
    PIVOT 
    (
            MAX(value) FOR name IN 
            (
              'HMETHOD' AS HMETHOD,
              'HPRECISION' AS HPRECISION,
              'HREF' AS HREF
            )
    );

ID	HMETHOD	HPRECISION	HREF
1001	96	5	-1
1002	90	4	unknown