clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2555381 fiddles created (37426 in the last week).

select * from V$VERSION;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production Version 18.4.0.0.0 Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production 0
 hidden batch(es)


create table t1 (js varchar(100));
 hidden batch(es)


insert into t1 values ('{"foo":"bar"}');
1 rows affected
 hidden batch(es)


select * from t1 left join json_table(t1.js, '$' columns (col varchar(10) path '$.foo')) T on t1.js is not null;
JS COL
{"foo":"bar"} bar
 hidden batch(es)


select * from t1 right join json_table(t1.js, '$' columns (col varchar(10) path '$.foo')) T on t1.js is not null;
JS COL
{"foo":"bar"} bar
 hidden batch(es)