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.

• 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.

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.

• 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.