Home » SQL & PL/SQL » SQL & PL/SQL » compare two num,varchar column in two table (oracle 9 , linux)
compare two num,varchar column in two table [message #437285] Sun, 03 January 2010 03:50 Go to next message
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
Re: compare two num,varchar column in two table [message #437286 is a reply to message #437285] Sun, 03 January 2010 04:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
=
!=
>
<
>=
<=
Are these not sufficient?
And this is NOT an administration question.

Regards
Michel
Re: compare two num,varchar column in two table [message #437287 is a reply to message #437286] Sun, 03 January 2010 04:21 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Is there any function similar to "dbms_lob.compare"..
?? similar function like dbms_lob.compare ???
any suggestion ???
Re: compare two num,varchar column in two table [message #437288 is a reply to message #437287] Sun, 03 January 2010 04:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Instead of repeating the question, answer mine.
Why the comparison operator does not fit your needs?

Regards
Michel
Re: compare two num,varchar column in two table [message #437289 is a reply to message #437288] Sun, 03 January 2010 04:37 Go to previous messageGo to next message
chuikingman
Messages: 90
Registered: August 2009
Member
Any example???
Re: compare two num,varchar column in two table [message #437290 is a reply to message #437289] Sun, 03 January 2010 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Example of what?
string1 < string2

Why don't you explain what are your needs? With examples.

Regards
Michel
Re: compare two num,varchar column in two table [message #437330 is a reply to message #437285] Sun, 03 January 2010 23:12 Go to previous message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Is this you are Looking For ?

sriram Smile
Previous Topic: Is multi threading technical in pl/sql concept?
Next Topic: how to write update statement for this
Goto Forum:
  


Current Time: Thu Feb 13 15:37:18 CST 2025