My 2 cents
Stew Ashton, November 05, 2020 - 10:04 am UTC
I've worked with XML and studied the JSON stuff.
- The JSON stuff has better performance overall.
- What you probably need most as a "function" is either XMLTABLE or JSON_TABLE. One advantage of JSON_TABLE is that it supports the NESTED PATH syntax, which is easier to understand and get right than the XMLTABLE equivalent.
- If you have to do complicated transformations, XML allows you to use the XQUERY language. There is no equivalent in JSON.
Personally, I would be tempted to code both solutions as a learning exercise and choose afterwards. If you don't have time for that, and since you are lucky enough to be on 19c, go with JSON.
Best regards,
Stew Ashton
November 05, 2020 - 10:19 am UTC
Thanks for your thoughts Stew
Praveen, November 05, 2020 - 10:54 am UTC
Thank you so much Stev and Chris