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?