drop table t purge
ORA-00942: table or view does not existMore Details: https://docs.oracle.com/error-help/db/ora-00942
create table t
(json_data blob)
Table created.
insert into t values (
utl_raw.cast_to_raw (
'{"testing":"information"}'
)
)
1 row(s) inserted.
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 |
---|