SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE mytable ( id int, myclob_column clob, column3 int ); insert into mytable select 1, '{ "name" : "Rahul1", "address" : [ {"street" : "100"}, {"street" : "200"}], "channel" : ["A", "B"] }', 1 from dual; insert into mytable select 2, '{ "name" : "Rahul", "address" : [ {"street" : "100"}, {"street" : "300"}], "channel" : ["A", "B"] }', 2 from dual; select t.*, s.street, c.channel from mytable t, json_table( myclob_column , '$.address[*]' COLUMNS ( street PATH '$.street' ) ) s , json_table( myclob_column , '$.channel[*]' COLUMNS ( channel PATH '$' ) ) c where street = 200 and channel = 'A'