New JSON Data Type

JSON is a new SQL and PL/SQL data type for JSON data. It provides a substantial increase in query and update performance.

JSON data type is optimized for query and DML processing. It can yield database performance improvements for processing JSON data.

You can use JSON data type and its instances in most places where a SQL data type is allowed, including:

  • As the column type for table or view DDL
  • With SQL/JSON functions and conditions, and with PL/SQL procedures and functions
  • In Oracle dot-notation query syntax
  • For creation of functional and search indexes

Oracle Call Interface and Java Database Connectivity (JDBC) clients now provide APIs that can work directly with binary JSON data, significantly saving network costs and server CPU cycles.