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!

difference of CLOB Fields

user13393409Oct 4 2010 — edited Oct 4 2010

Hi ,

am using CLOB fields in few of my tables, but when i use the minus query its not showing proper result.

Ex : select ename from emp1
MINUS
select ename from emp2

assume ename is a field of dat type clob, in this case am getting error meaage inconsistent clob datatype .

any suggestions???

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 1 2010

Added on Oct 4 2010

6 comments

4,815 views