select case
when json_equal (
'{"comparesAttributes":"and values"}', '{"inTwoJSONDocuments": "for equality"}'
) then 'the same' else 'different'
end json_compare
from dual
JSON_COMPARE | different |
---|
select case
when json_equal (
'{"ifTheyAreIdenticalTheResultIs":true}',
'{"ifTheyAreIdenticalTheResultIs":true}'
) then 'the same' else 'different'
end json_compare
from dual
JSON_COMPARE | the same |
---|
select case
when json_equal (
'{"whitespace":"is ignored"}',
'{
"whitespace": "is ignored"
}'
) then 'the same' else 'different'
end json_compare
from dual
JSON_COMPARE | the same |
---|
select case
when json_equal (
'{"attribute": "order", "matters":"not"}',
'{"matters":"not", "attribute": "order"}'
) then 'the same' else 'different'
end json_compare
from dual
JSON_COMPARE | the same |
---|
select case
when json_equal (
'{"arrayElementOrder": ["does", "matter"]}',
'{"arrayElementOrder": ["matter", "does"]}'
) then 'the same' else 'different'
end json_compare
from dual
JSON_COMPARE | different |
---|