Reputation: 428
I was trying extract value in SQL developer from below json but it gives me wrong output
select
json_value('{"ABC": {
"CFF": 90,
"coord": {
"x1": 27.4,
"x2": 31.6,
"y1": 61.4,
"y2": 62.4
},
"value": "\\"
}}','$."ABC".value') COL from dual
Kindly suggest ..
Upvotes: 0
Views: 333
Reputation: 11192
The backslash symbol \
is also an escape character - so \\
in a quoted string "\\"
becomes a single unescaped \
If you want the value to be \\
you have to double the amount of backslashes to \\\\
Upvotes: 1