The JSON search index supports RANGE and LIST partitioned tables.A new, simplified syntax makes it easier to create a JSON search index.JSON path expressions used with JSON_EXISTS condition now support predicates.The JSON path expressions used with simplified syntax for querying JSON now support navigating to specific members of an array.This release incorporates significant support enhancements for storing and querying JavaScript Object Notation (JSON) documents for Oracle Database. Support for ISO, IEC and ANSI SQL standard syntax simplifies application migration to Oracle Database from non-Oracle Database systems that support column-level collation declarations. It enables developers to optimally address applications where only some of the data needs language or region-specific sorting rules. The column-level collation capability simplifies application development and provides greater flexibility for creating applications. The declared collation is automatically applied by all collation-sensitive SQL operations referencing the column. The column-level collation allows you to declare the sort ordering on a column level, using syntax and semantics compatible with the ISO, IEC and ANSI SQL standard. Numerous collations supported by Oracle Database can order strings according to conventions used in dictionaries, names lists and other sorted text written in many languages of the world. Collation (also called sort ordering) determines if a character string equals, precedes or follows another string when the two strings are compared and sorted.
0 kommentar(er)
