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.

Report message to a moderator

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: 3211
Registered: January 2010
Location: Connecticut, USA
Senior Member
Use APEX_JSON.WRITE

SY.

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Mar 20 03:39:46 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.