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!

NVL Function on CLOB data type

RedeAug 5 2011 — edited Aug 5 2011

Hi all,

I am not able to use the NVL function over clob..please suggest me a way to do the data validation of the CLOB in sql ....

below is the query i was using...

select t1.pic_name,t2.pic_name
from table1 t1,table2 t2
where nvl(t1.picture_message,'X') <> nvl(t2.picture_message,'X');

i am getting the following error....

ORA-00932: inconsistent datatypes: expected - got CLOB

Thanks
Rede

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 2 2011

Added on Aug 5 2011

9 comments

7,297 views