JSON

Scoop – First glance of the new Oracle Live SQL?

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

Oracle Database 12.2.0.1 – PL/SQL JSON functionality

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

Oracle Database 12.2.0.1 – Generating JSON in the Database using SQL/JSON operators

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

Oracle Database – JSON en de In-Memory Database

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

Oracle 12c: Indexing JSON in the Database Part III (Paperback Writer)

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 […]

Oracle 12c: Indexing JSON in the Database Part II (Find A Little Wood)

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, […]