DEV Community

Query Filter
Query Filter

Posted on

blob

CASE
  WHEN DBMS_LOB.SUBSTR(clob_col, 1000, 1) =
       UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(blob_col, 1000, 1))
  THEN 'MATCH'
  ELSE 'NO MATCH'
END

Enter fullscreen mode Exit fullscreen mode

Top comments (0)