I am having some issues on extracting data from a field called “JSON” which is a clob inside a table in Oracle SQL.
For example, i have a table called Pippo which has the following data:

id : 1,2,3
Value : a, b, c

And I have inside my table called “JSON_TEST” my JSON field which has the following format : {“from: “Pippo”}

I would to use the JSON function to make a query (or function) that have takes my table from the JSON field and return Pippo’s values.

like : Select * (from JSON field).

In other words, i would to extract Pippo’s values from the JSON present inside JSON_TEST