json validation

ravi29 Member Posts: 1 Green Ribbon

Hi Friends,

Can anybody tell me that whether we can verify JSON data is valid or invalid in oracle(12c).

Basically I have one table where JSON data is inserted. Before transfer this data to another table i need to validate if JSON is valid or invalid.

Thanks in Advance,


  • kris smith
    kris smith Member Posts: 0 Green Ribbon

    Hello Ravi

    you can find some info on json on below reference


  • Subhodip Das
    Subhodip Das Member Posts: 0 Green Ribbon

    Hello, please do the process online. If you do it manually then there have a chance for error. Go to Micro Data Generator Tool and use it as per your requirement.