compare two num,varchar column in two table [message #437285] |
Sun, 03 January 2010 03:50  |
chuikingman
Messages: 90 Registered: August 2009
|
Member |
|
|
Hi,
I have two tables with number,varchar column.
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_ENV VARCHAR2(1024)
SQL> desc ckm2
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_ENV VARCHAR2(1024)
Is there any function similar to "dbms_lob.compare"..
So, two field of two text column in different table can be compared??
Any example ??
Any advice on this??
Any comment
|
|
|
|
|
|
|
|
|