JSON predicate

Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition

The JSON predicate can be used to check if a given expression is valid JSON

SELECT 1
FROM dual
WHERE '{}' IS JSON
AND '{' IS NOT JSON

create.selectOne()
      .where(val("{}").isJson())
      .and(val("{").isNotJson())
      .fetch();

Do you have any feedback about this page? We'd love to hear it!

Community