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!

Convert long to varchar2 or clob in pure Oracle SQL

qwestionAug 15 2012 — edited Aug 15 2012
Hi

Please assist, query below has a column that has a long datatype and it gets compared to a varchar2 and we keep getting an 'incostistence between the convertion of the long'

Please note, message is defined as LONG

Query:
select message, id from employees where message not in ('Charles')

Thanks
Amos
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2012
Added on Aug 15 2012
5 comments
24,373 views