Dealing with JSON data in Oracle: DOs and DON'Ts

JSON_TABLE columns can have different semantics: JSON_VALUE, JSON_QUERY, JSON_EXISTS all options supported Write on JSON_TABLE with multiple columns instead of SELECT JSON_VALUE, JSON_VALUE, JSON_QUERY FROM … WHERE JSON_EXISTS ................
................