Kayshav.com
About Developer Oracle 19c Oracle 12c Technology Information Sitemap

Oracle JSON_TABLE
-- 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 
;

JSON_TABLE


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

Nested



  Oracle 19c Index   Oracle Functions

  JSON_ARRAY   JSON_OBJECT   JSON_SERIALIZE   JSON Updates

  Lower Versions   11g Index   12c Index
Top

Oracle registered trademark of Oracle Corporation.

Last Revised On: January 27th, 2021

  5058