Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table myTable (id, data) as
select 1, '["a", "b"]' from dual union all
select 2, '["a", "b", "c"]' from dual union all
select 3, '["b", "a"]' from dual
3 rows affected

create type t_string as table of varchar2(1)
/
select *
from myTable
where json_value(data, '$' returning t_string) = json_value('["a", "b"]', '$' returning t_string)


ID
DATA


1
["a", "b"]

3
["b", "a"]


select *
from myTable
where json_value(data, '$' returning t_string) = json_value('["c", "a", "b"]', '$' returning t_string)


ID
DATA


2
["a", "b", "c"]


select *
from myTable
where json_value(data, '$' returning t_string) = json_value('["d"]', '$' returning t_string)