code: proc sql _method ; connect to oracle(user=user password='password' PATH = pathname); execute (alter session set current_schema = schema) by oracle; create table table as select * from connection to oracle ( select j.*,d.JSON_field1 ,d.JSON_field2 from user.tableora d, json_table ( d.JSON_field2, '$' columns ( id PATH '$.idnum', date1 PATH '$.date1', date2 PATH '$.date2') )j WHERE json_exists(d.JSON_field1 , '$[*]?(@.idnum == 11)') ); DISCONNECT FROM ORACLE; quit; LOG: NOTE: SQL execution methods chosen are: sqxcrta sqxextr( connection to oracle /* dbms=oracle, connect options=(user=user password=XXXXX PATH = pathname) */ ( select j.*,d.JSON_field ,d.JSON_field2 from user.tableora d, json_table ( d.JSON_field2, '$' colum ... ) ) NOTE: Table WORK.TABLE created, with 0 rows and 5 columns.
... View more