New versions: Dev (3.15) | Latest (3.14)


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

The JSON_VALUE function is used to extract content from JSON documents using a JSON path expression.

SELECT json_value(
FROM dual

The result would look like this:

| json_value |
| 2          | 

If the value does not matter, but you just want to check for a value's existence, use the JSON_EXISTS predicate.


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

The jOOQ Logo