CREATE TABLE "T"  
   (	"COLUMN1" VARCHAR2(40 BYTE),  
	"COLUMN2" VARCHAR2(40 BYTE) 
   )

Insert into T (COLUMN1,COLUMN2) values ('Soda: 10, Watter:5, Juice: 12','Soda: 7, Watter:20, Juice: 15')

Insert into T (COLUMN1,COLUMN2) values ('Soda: 10, Watter:2, Juice: 12','Soda: 7, Watter:2, Juice: 15')

SELECT *
FROM (
     SELECT '{' || column1 || '}' AS column1,
            '{' || column2 || '}' AS column2
     FROM t
)
WHERE 
JSON_VALUE(column1,'$.Watter' ) <> JSON_VALUE(column2,'$.Watter' );