Appendixes

Appendixes here provide background material for using JSON data with Oracle Database.

• ISO 8601 Date, Time, and Duration Support
  International Standards Organization (ISO) standard 8601 describes an internationally accepted way to represent dates, times, and durations. Oracle Database supports the most common ISO 8601 formats as proper Oracle SQL date, time, and interval (duration) values. The formats that are supported are essentially those that are numeric-only, language-neutral, and unambiguous.
• Oracle Database JSON Capabilities Specification
  This appendix specifies capabilities for Oracle support of JSON data in Oracle Database.
• Diagrams for Basic SQL/JSON Path Expression Syntax
  Syntax diagrams and corresponding Backus-Naur Form (BNF) syntax descriptions are presented for the basic SQL/JSON path expression syntax.
• Migrating Textual JSON Data to JSON Data Type
  Oracle recommends that you use native binary JSON data (type JSON), rather than textual JSON data (type VARCHAR2, CLOB, or BLOB). How to migrate existing textual JSON data to JSON type is described. This involves (1) a pre-upgrade check, (2) migrating the data, and (3) dealing with dependent database objects.