JSON parsing? [message #635475] |
Mon, 30 March 2015 16:26 |
|
JDOaktown
Messages: 7 Registered: March 2015
|
Junior Member |
|
|
Here is my JSON stored in a CLOB column:
select upJSON from myLocations;
{"values":[
{"nameValuePairs":{"upJSON":"{\"mResults\":[0.0,0.0],\"mProvider\":\"fused\",\"mDistance\":0.0,\"mAltitude\":0.0}","id":"1","updated":"2015-03-30 20:28:51"}},
{"nameValuePairs":{"upJSON":"{\"mResults\":[0.0,0.0],\"mProvider\":\"FINDME\",\"mDistance\":0.0,\"mAltitude\":22.2}","id":"2","updated":"2015-03-30 20:28:53"}},
{"nameValuePairs":{"upJSON":"{\"mResults\":[0.0,0.0],\"mProvider\":\"fused\",\"mDistance\":0.0,\"mAltitude\":0.0}","id":"3","updated":"2015-03-30 20:28:55"}},
{"nameValuePairs":{"upJSON":"{\"mResults\":[0.0,0.0],\"mProvider\":\"fused\",\"mDistance\":0.0,\"mAltitude\":0.0}","id":"4","updated":"2015-03-30 20:28:57"}}
]}
(I have inserted newlines for clarity)
Please: What is the SQL (or PL/SQL) needed to select just the value of mProvider, mAltitude, and the id from the 2nd "nameValuePairs" (= "FINDME" and 22.2 and "2") in the example above) ??
|
|
|
|
|
|
|
|
Re: JSON parsing? [message #635498 is a reply to message #635486] |
Tue, 31 March 2015 01:53 |
|
Michel Cadot
Messages: 68648 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Littlefoot wrote on Tue, 31 March 2015 07:52LOL! Since when is someone, whose location is "Nanterre, France", a stupid amerikahn?
As his IP is from Oakland, CA, USA, I think he is talking about him.
[Updated on: Tue, 31 March 2015 01:53] Report message to a moderator
|
|
|
|
|
|
|
|
|