Oracle 21c

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 21c Express Edition Release 21.0.0.0.0 - Production
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
Version 21.3.0.0.0
Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production
0


-- the native JSON type arrived in Oracle 21c
create table doc (id number, body json)
insert into doc
select 1, json('{"name":"ann","tags":["sql"]}') from dual union all
select 2, json('{"name":"bob","tags":["graph"]}') from dual

2 rows affected


select id
     , json_value(body, '$.name') as name
     , json_query(body, '$.tags') as tags
from doc order by id


ID
NAME
TAGS


1
ann
["sql"]

2
bob
["graph"]