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.
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