-- Oracle 21c: JSON_TRANSFORM

wITH jtab AS
 (SELECT  
   JSON('{"Name"    :  "Json  Oracle",
          "Address" :
            {"Street"   : "123 Redwood Street",
             "City"     : "South San Francisco",
             "State"    : "CA",
             "ZipCode"  : "99636",
             "Country"  : "United States of America"
            }
         }'
      ) AS json_col
  FROM  DUAL
 )
SELECT
  JSON_TRANSFORM(jt.json_col,  REMOVE '$."Name"'
                   RETURNING  CLOB  PRETTY) 
              JSON_TRANSFORM_OP
FROM  jtab jt
;


-- Oracle 19c: JSON_TRANSFORM

wITH jtab AS
 (SELECT  --JSON(
    '{"Name"    :  "Json  Oracle",
          "Address" :
            {"Street"   : "123 Redwood Street",
             "City"     : "South San Francisco",
             "State"    : "CA",
             "ZipCode"  : 99236,
             "Country"  : "United States of America"
            }
     }'             --)
       AS json_col
  FROM  DUAL
 )
SELECT
  JSON_TRANSFORM(jt.json_col,  REMOVE '$."Name"'
                   RETURNING  CLOB  PRETTY) 
              JSON_TRANSFORM_OP
FROM  jtab jt
;



-- Name removed in the JSON text