Changes in SODA

Changes in Oracle Database Release 18c for SODA

New Features for Oracle Database Release 18c

New features for Oracle Database Release 18c include new QBE item methods, new data types for QBE operator $orderby, and B-tree indexing with additional data types.

Note:

Supported features can vary among SODA implementations. The new features listed here are not necessarily supported by all implementations.

  • New item methods: $abs, $date, $size, $timestamp, and $type.

  • Use of data types date and timestamp with QBE operator $orderby.

  • B-tree indexing with date and timestamp data types.

Changes in Oracle Database Release 12c (12.2.0.1) for SODA

New Features for Oracle Database Release 12c (12.2.0.1)

New features for Oracle Database Release 12c (12.2.0.1) include QBE item methods, support for indexing, and support for proximity and full-text searching of JSON documents.

Note:

Supported features can vary among SODA implementations. The new features listed here are not necessarily supported by all implementations.

  • Item methods for QBE — Use QBE item methods ($boolean, $ceiling, $double, $floor, $length, $lower, $number, $string, $upper) to transform matched data before filtering it further.

  • GeoJSON proximity search — Use query-by-example (QBE) to select documents that have a field whose value is a GeoJSON geometry object that is near a specified position, intersects a specified geometric object, or is within another specified geometric object.

  • Full-text search — Use QBE to select documents with fields whose value matches a given string or number.

  • Indexing — Index documents in a collection: B-tree, GeoJSON geometry (spatial), and JSON search.