DBA Hub

📋Steps in this guide1/18

JSON Support Enhancements in Oracle Database 23ai/26ai

Oracle 23ai/26ai includes several enhancements to the JSON functionality in the database. This post acts as a links page to separate articles on each feature.

oracle 23configurationintermediate
by OracleDba
14 views
1

GraphQL

Oracle database 23ai/26ai includes GraphQL support from SQL. - GraphQL in Oracle Database 23ai/26ai
2

JSON Collections

Oracle database 23ai/26ai introduced JSON collections, which are specifically for use with the Oracle Database API for MongoDB and Simple Oracle Document Access (SODA). - JSON Collections in Oracle Database 23ai/26ai
3

JSON_ARRAY Using Subqueries

From Oracle database 23ai/26ai onward the function can accept a subquery as input, which brings it in line with the current SQL/JSON standard. - JSON_ARRAY Using Subqueries in Oracle Database 23ai/26ai
4

JSON Schema

In Oracle 23ai/26ai a JSON Schema can validate the structure and contents of JSON documents in your database. - JSON Schema in Oracle 23ai/26ai
5

JSON Data Type Constructor Enhancements

The JSON data type constructor can now accept collections, object types and record types as input. - JSON Data Type Constructor Enhancements in Oracle Database 23ai/26ai
6

JSON_VALUE Function Enhancements

The JSON data type constructor can now accept collections, object types and record types as input. - JSON_VALUE Function Enhancements in Oracle Database 23ai/26ai
7

JSON_SERIALIZE : ORDERED Keyword

In Oracle 23ai/26ai the keyword has been added to the function. When present, the members are serialized in ascending alphabetical order by field name. - JSON_SERIALIZED : ORDERED Keyword in Oracle Database 23ai/26ai
8

JSON_TRANSFORM Enhancement

In Oracle 23ai/26ai the function has lots of new operations, conditional control and richer path support. - JSON_TRANSFORM Enhancements in Oracle Database 23ai/26ai
9

DBMS_JSON.JSON_TYPE_CONVERTIBLE_CHECK

In Oracle 23ai/26ai the JSON_TYPE_CONVERTIBLE_CHECK procedure has been added to the DBMS_JSON package to allow pre-migration checks to be performed on text-based JSON columns. - Migrating Text-Based JSON to JSON Data Type : Pre-Migration Check in Oracle Database 23ai/26ai
10

Loading JSON Data using External Tables

In Oracle database 23ai/26ai loading JSON data using external tables got much simpler. - Loading JSON Data using External Tables in Oracle Database 23ai/26ai
11

Loading SODA Collections with SQL*Loader

In Oracle 23ai we can use SQL*Loader to load JSON data into a Simple Oracle Document Access (SODA) collection. - Loading SODA Collections with SQL*Loader in Oracle Database 23ai/26ai
12

ORDS : AutoREST of JSON-Relational Duality Views

The AutoREST functionality of Oracle REST Data Services (ORDS) has been extended to include JSON-relational duality views in Oracle 23ai/26ai. - Oracle REST Data Services (ORDS) : AutoREST of JSON-Relational Duality Views
13

Precheck Constraints using JSON Schema

In Oracle database 23ai/26ai we can use the keyword to mark check constraints as being validated externally by an application. - Precheck Constraints using JSON Schema in Oracle Database 23ai/26ai
14

Predicates for JSON_QUERY and JSON_VALUE

In Oracle database 23ai/26ai the and functions can include multiple predicates in a single JSON path expression, and use the clause to support variables. - Predicates for JSON_QUERY and JSON_VALUE in Oracle Database 23ai/26ai
15

XML, JSON and Oracle Text Search Index Enhancements

In Oracle 23ai/26ai the statement allows us to create search indexes on XML, JSON and text data, making the syntax consistent between them. - XML, JSON and Oracle Text Search Index Enhancements in Oracle Database 23ai/26ai
16

EMPTY STRING ON NULL for JSON Generation

Oracle database 23ai/26ai has introduced the ability to convert nulls to empty strings during JSON generation. - EMPTY STRING ON NULL for JSON Generation in Oracle Database 23ai/26ai
17

JSON_BEHAVIOR Parameter

By default many JSON functions return null if they encounter a runtime error. Oracle database 23ai/26ai introduced the JSON_BEHAVIOR parameter to allow us to alter this default behaviour for our session. - JSON_BEHAVIOR Parameter in Oracle Database 23ai/26ai
18

JSON Type Modifiers

Oracle database 23ai/26ai (23.8) allows greater control over the contents of JSON columns stored in the database using JSON type modifiers. - JSON Type Modifier Enhancements in Oracle Database 23ai/26ai For more information see: Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!