Requires manual parsing in PL/SQL procedures. Oracle Database 12.1.0.2 First introduction of JSON_TABLE, JSON_QUERY, and JSON_VALUE SQL functions. Allows direct JSON parsing within SQL queries.
This automated approach helps eliminate inconsistencies caused by variations in user queries and helps deliver more consistent and reliable information for investigative analysts, said Oracle. These ...