What version? I get this on mine
SQL>
SQL> create table t (
2 c1 int, json_data varchar2(100)
3 );
Table created.
SQL>
SQL> insert into t values ( 1, '{"country_codes": ["IND"], "regions": ["ASIA"]}' );
1 row created.
SQL> insert into t values ( 2, '{"country_codes": ["IND","USA"], "regions": ["ASIA","NA"]}' );
1 row created.
SQL> commit;
Commit complete.
SQL>
SQL> select *
2 from t
3 where json_exists(JSON_DATA, '$.regions?(@=="NA")');
C1 JSON_DATA
---------- ----------------------------------------------------------------------------------------------------
2 {"country_codes": ["IND","USA"], "regions": ["ASIA","NA"]}
1 row selected.
SQL>
SQL> drop table t purge;
Table dropped.
SQL>
SQL> create table t (
2 c1 int, json_data clob
3 );
Table created.
SQL>
SQL> insert into t values ( 1, '{"country_codes": ["IND"], "regions": ["ASIA"]}' );
1 row created.
SQL> insert into t values ( 2, '{"country_codes": ["IND","USA"], "regions": ["ASIA","NA"]}' );
1 row created.
SQL> commit;
Commit complete.
SQL>
SQL> select *
2 from t
3 where json_exists(JSON_DATA, '$.regions?(@=="NA")');
C1 JSON_DATA
---------- --------------------------------------------------------------------------------
2 {"country_codes": ["IND","USA"], "regions": ["ASIA","NA"]}
1 row selected.
SQL>
SQL>