with q as ( select '{"a":"b"}' j from dual union all select 'hello' j from dual ) select * from q WHERE j IS JSON