Skip to Main Content

Oracle Database Free

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Syntax of JSON_TRANSFORM operations CASE, COPY, INTERSECT, MERGE, MINUS, PREPEND and UNION is not documented

Philipp SalvisbergJan 2 2024 — edited Jan 2 2024

The following JSON_TRANSFORM operations are documented in the SQL Language Reference 23c https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/JSON_TRANSFORM.html#GUID-DD2A821B-C688-4310-81B5-5F45090B9366__GUID-D5868C5C-960B-4C87-89D4-C8B077F9B3BB :

sort and nested_path_op were added in 23c. However, in the JSON Developer's Guide 23c, the additional 7 operations mentioned in the title are documented, but without syntax diagrams. See https://docs.oracle.com/en/database/oracle/oracle-database/23/adjsn/oracle-sql-function-json_transform.html#GUID-7BED994B-EAA3-4FF0-824D-C12ADAB862C1 .

IMO the syntax for these operations cannot be derived from this documentation. At least not fully.

Is there a reason why the syntax diagrams for the operations CASE, COPY, INTERSECT, MERGE, MINUS, PREPEND and UNION are not provided in the SQL Language Reference?

This post has been answered by gsalem-Oracle on Jan 3 2024
Jump to Answer
Comments
Post Details
Added on Jan 2 2024
1 comment
138 views