This is not the exact solution for you query, but might help you better if
you add the libraries.
*-- *Kishore Kumar Vaishnav
On Thu, Mar 20, 2014 at 11:35 AM, Sukhjinder K. Narula
> I would like to know if there is a way to decode the json string stored in
> one of the fields as text without using triggers or stored procedures.
> What I want to do is is within the query, I would like to get one row per
> element within the json string.
> For example: the json string is as follow:
> "name" : "Abc",
> "age" : "20"
> "name" : "Xyz",
> "age" : "18"
> and after query, I want result as:
> Name Age
> Abc 20
> Xyz 18
> Would this be possible, I greatly appreciate any help regarding this
> Many Thanks,