Oracle 21C JSON MODIFICATION
Hi all,
I am trying to find a way to update JSON data stored in a json datatype column.
The simplified JSON value that I want to modify is:
{
"type": "QAR",
"status_val": "200",
...
}
For the status_val element I want to change the type. Actually it is a string value but I want to put an INT value instead.
The result would be:
{
"type": "QAR",
"status_val": 200,
...
}
Is it possible to do that using the JSON_TRANSFORM function? If yes, how?
Best regards.
0