JSON

For people interested, here the slide desks used internally to debrief my colleagues regarding Oracle…

Here the presentation slide deck (100+) used during the oGH Dutch Usergroup session and (partially…

When I was at OOW this year I saw the new (?) Oracle Live SQL…

One functionality area in Oracle Database 12.2.0.1 that now also supports the handling of JSON…

Maybe not so evident to make a second post about Oracle 12.2.0.1 about the JSON…

Oracle 12.2 is available, although still only in the Oracle Cloud via Oracle’s Exadata Express…

Op maandag 24 oktober vindt er een bijeenkomst plaats over JSON en de In-Memory Database…

In Part I and Part II, we looked at how to index specific attributes within a JSON document store within an Oracle 12c database. But what if we’re not sure which specific attributes might benefit from an index or indeed, as JSON is by it’s nature a schema-less way to store data, what if we’re not entirely sure […]

In Part I, we looked at how you can now store JSON documents within the Oracle 12c Database. For efficient accesses to JSON documents stored in the Oracle database, we can either create a function-based index based on the JSON_VALUE function or on JSON .dot notation. These indexes are useful for indexing specific JSON attributes, […]

One of the very cool new features introduced in Oracle Database 12c Rel 1 is the ability to store JavaScript Object Notation (JSON) documents within the database. Unlike XML which has its own data type, JSON data can be stored as VARCHAR2, CLOB or BLOB data types, but with a JSON check constraint to ensure the […]