Generating deep nested JSON palyload out of Oracle SQL
I have a need to generate a three level nested JSON payload out of Oracle tables. I have described two approaches I have used to accomplish this and neither of them work. Please advise where am I going wrong! Approach…