-- Oracle JSON Function - JSON_TABLE

SELECT
   jt.properties_val
  ,jt.languages
FROM 
  all_mining_algorithms,
  JSON_TABLE(algorithm_metadata, 
             '$.properties.algo_name_display.properties') 
     COLUMNS(properties_val  VARCHAR2(100) FORMAT JSON PATH '$.language[*]',
             languages       VARCHAR2(100) FORMAT JSON PATH '$.language.enum')
   ) as jt 
;




SELECT t.*
FROM  all_mining_algorithms 
NESTED algorithm_metadata COLUMNS(type) t
;