looking for some solutions? You are welcome.

SOLVED: Oracle Sql Not Giving Result: Count Json Objects Inside Json Array

Arundhati Navada:

JSON COLUMN IN TABLE: DATA

{
  "TEST":"ABCD",
  "RESULT":[{"APPLES","ORANGES","GRAPE"},{"APPLES","GRAPE"},{"APPLES","ORANGES"}]
 }

I want out put : APPLES: 3 ORANGES:2 GRAPES: 2

I want to know how to do this in SQL



Posted in S.E.F
via StackOverflow & StackExchange Atomic Web Robots
Share:

No comments:

Recent