json validation

ravi29
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,

Comments

  • kris smith
    kris smith Member Posts: 0 Green Ribbon

    Hello Ravi


    you can find some info on json on below reference


    oracle-base/articles/12c/json-support-in-oracle-database-12cr1

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