Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    55

    Unanswered: compare TWO CLOB cloumn in two table

    Hi,
    I have two table with identical column.
    There is CLOB column,
    How I can compare two CLOB column are identical or different in two table ??
    Any advice
    Below is the column of table

    SQL> desc ckm1
    Name Null? Type
    ----------------------------------------- -------- ----------------------------
    N_COMP_ID NOT NULL NUMBER(10)
    C_COMP_NAME NOT NULL VARCHAR2(120)
    C_HOSTNAME VARCHAR2(20)
    N_FRWK_COMP_FLAG NOT NULL NUMBER(1)
    C_COMP_ARGS CLOB
    C_COMP_ENV VARCHAR2(1024)

  2. #2
    Join Date
    May 2004
    Posts
    95
    if you wish to compare the binary content of each CLOB column, you can use the dbms_lob.compare function.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •