By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
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 |
create table samp(js VARCHAR2(100));
insert into samp values('["a","b","c"]');
1 rows affected
SELECT value
FROM json_table( (select js from samp) , '$[*]'
COLUMNS (value PATH '$'
)
)
| VALUE |
|---|
| a |
| b |
| c |