Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

comparision of CLOB data types

user13490153Feb 4 2013 — edited Feb 5 2013
HI All,
Can anybody guide me how to how to compare two columns of data type CLOB from same table.

For e.g. I have emp table with test1 and test2 fields of datatype CLOB.

My content in test1 is id:=100|Name:=Rajesh|sal:=2000
My conent in test2 is id:=200|Name:=Rajesh|sal:4000

Now I need to compare test1 id with test2 id and should print the result like id and salary is mismatching.
Here for e.g. I showed 3 values but I have many values to compare.

Thanks in advance for your efforts!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2013
Added on Feb 4 2013
2 comments
305 views