drop table t purge
create table t
(json_data blob)
insert into t values (
utl_raw.cast_to_raw (
'{"testing":"information"}'
)
)
select case
when json_equal (json_data, '{"testing":"information"}')
then 'same' else 'different'
end as result
from t
RESULT | same |
---|
select case
when json_equal (json_data, '{"testing":"different"}')
then 'same' else 'different'
end as result
from t
RESULT | different |
---|
select case
when json_equal (json_data, '{"testing"
:
"information"}')
then 'same' else 'different'
end as result
from t
RESULT | same |
---|