oracle中对clob字段查询总失败

[sky_1989]

select * from meetingroom where sysuserid like 'roomone' or sysuserid='allroom'
sysuserid为clob字段！这样写总报ORA-00932: 数据类型不一致，应为 - ，但却获得CLOB

[cosio]

select * from meetingroom where to_char(sysuserid) like 'roomone' or sysuserid='allroom' 

[liusong_china]

[Quote=引用楼主 sky_1989 的回复:]
select * from meetingroom where sysuserid like 'roomone' or sysuserid='allroom'
sysuserid为clob字段！这样写总报ORA-00932: 数据类型不一致，应为 - ，但却获得CLOB
[/Quote]

select * from meetingroom where sysuserid like 'roomone' or to_char(sysuserid)='allroom'

like不用转，=要转类型。