Home » SQL & PL/SQL » SQL & PL/SQL » xml to json conversion (Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production)
xml to json conversion [message #681845] Thu, 03 September 2020 22:56 Go to next message
wantmannu
Messages: 42
Registered: June 2009
Location: cali
Member

There is a Oracle Table which has a column which has xml data. I am planning to create another column to hold json data. Is there any way PLSQL or APEX has a function which can convert the data in xml column and place it in json in json type converted file.
Re: xml to json conversion [message #681853 is a reply to message #681845] Fri, 04 September 2020 05:11 Go to previous message
Solomon Yakobson
Messages: 3055
Registered: January 2010
Location: Connecticut, USA
Senior Member
Use APEX_JSON.WRITE

SY.
Previous Topic: Oracle: create a partition by reference (partition by reference(fk)) on non referenced table
Next Topic: to_timestamp_tz
Goto Forum:
  


Current Time: Wed May 12 15:50:14 CDT 2021