How to enforce structure/rules on a JSON document
I couldn't find a section designated specifically to JSON, so sorry if this question is misplaced.
I'm wondering if Oracle (19c) allows JSON document validation which goes beyond merely checking if the document is a valid JSON.
For example, in MongoDB one could define a schema and enforce some rules like this:
var schema = {
"id": "/All",
"type": "object",
"properties": {
"city": {"type": "object", "required": true},
"phone": {"type": "string", "required": false },
"misc": {"type": "string", "required": false },
"population": {"type": "number", "required": true, "minimum": -100, "maximum": 100 }
}
}
Wondering if Oracle has the same feature.
In other words, looking for something that goes beyond a rudimentary check constrain like this: