https://docs.oracle.com/en/database/oracle/oracle-database/26/adjsn/mismatch-clause-sql-json-query-functions.html
You can use an ON MISMATCH clause with SQL/JSON functions json_value, json_query, and json_table, to handle type-matching exceptions. It specifies handling to...
json querymismatchclausesqlfunctions
https://www.alibabacloud.com/en/news/product/built-in-functions-json_tuple-and-extract-added-boz?_p_lc=1
MaxCompute SQL has added the JSON_TUPLE and EXTRACT built-in functions for more flexible user operations.
builtfunctionsjsontupleextract