By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
JSON_F52E2B61-18A1-11d1-B105-00805F49916B |
---|
[{"catid":100,"catname":"mycatname100","products":[{"product_id":1,"product_name":"productname1"},{"product_id":2,"product_name":"productname2"},{"product_id":3,"product_name":"productname3"}]},{"catid":200,"catname":"mycatname200","products":[{"product_id":1,"product_name":"productname1"},{"product_id":2,"product_name":"productname2"},{"product_id":3,"product_name":"productname3"}]},{"catid":300,"catname":"mycatname300","products":[{"product_id":1,"product_name":"productname1"},{"product_id":2,"product_name":"productname2"},{"product_id":3,"product_name":"productname3"}]}] |