Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with json
Search options not deleted
user 215901
JavaScript Object Notation (JSON) is an open, human and machine-readable standard that facilitates data interchange, and along with XML is the main format for data interchange used on the modern web.
1
vote
1
answer
2k
views
Updating a Json column that contains a JsonArray using Json_transform() function in Oracle D...
),
"SETTINGS" NCLOB NOT NULL CONSTRAINT settings_json CHECK ("SETTINGS" IS JSON),
UNIQUE(IDENTIFICATION_TYPE,IDENTIFICATION_CODE)
);
As you can see I have a Json column named SETTINGS. … the following query:
UPDATE USERS
SET SETTINGS = JSON_TRANSFORM(SETTINGS,
SET '$.watch_lists' =
'{ "liist_1": [4,5],"liist_2": [1,3,5] }'
FORMAT JSON …
- 111
0
votes
Accepted
Updating a Json column that contains a JsonArray using Json_transform() function in Oracle D...
It appears that it just isn't recognizing the json_transform() function - but it isn't clear exactly when it was added. It isn't mentioned in the "what's new" sections - though json_mergepatch() is. I …
- 111