Oracle 21 introduced a binary json type simply named {{json}}, which we should use for 21+ as that is fully integrated with everything and faster as well as more compact: [https://blogs.oracle.com/database/post/json-datatype-support-in-oracle-21c|https://blogs.oracle.com/database/post/json-datatype-support-in-oracle-21c]
On Oracle 12+, we should use {{blob}} instead of {{clob}}, according to Loïc Lefèvre, as that is more performant, because it’s denser, requires less conversion and works just as well with the JSON functions. |
|
