Hello, 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 matter. Many Thanks, Sukhjinder