Oracle 21c
About Developer Oracle 19c Oracle 12c Technology Information Sitemap

Oracle JSON_MERGEPATCH function
-- Oracle 21c: JSON_MERGEPATCH Function
-- JSON data can be revised as shown below
-- To remove data, the keyword "null" is case sensitive (as shown)

WITH json_data 
AS (
SELECT  '{ "Customer":"ABC Co.", "PONumber":1600}'  po_data 
FROM  DUAL
)
SELECT  po_data JSON_MERGEPATH_PO_Data
FROM  json_data
UNION
SELECT  JSON_MERGEPATCH(po_data, '{"Customer":"DEF Co."}')
FROM DUAL
FROM  json_data
UNION
SELECT  JSON_MERGEPATCH(po_data, '{"PONumber":99999}')
FROM DUAL
FROM  json_data
UNION
SELECT  JSON_MERGEPATCH(po_data, '{"PONumber":null}')  --Case sensitive 
FROM DUAL
FROM  json_data
;


JSON_MERGEPATCH


  Oracle 21c Index   Oracle Functions

  Lower Versions   19c Index   12c Index   11g Index

Top
Oracle registered trademark of Oracle Corporation.

Last Revised On: January 27th, 2021

  318