JSON data type
The growing popularity of JSON data and its easy implementation and use in mobile apps for the GET and POST methods of data transfer prompted Oracle to include the capability in Data Miner, which now provides an easy-to-use JSON Query node. The JSON Query node allows select and aggregate JSON data without entering any SQL commands. The JSON Query node opens, using all of the existing Data Miner features with JSON data. The enhancements include the following:
- Data Source node:
- Identifies all the columns containing JSON data by referring to the
IS_JSONconstraint - Generates JSON schema for any selected column that contains JSON data in XML format
- Imports JSON schema for a given column in XML format
- Using the JSON schema viewer, the data ...
- Identifies all the columns containing JSON data by referring to the
Get Oracle SQL Developer now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
