create table T
(
vs clob
)
insert into T values('中国');
insert into T values('0.5');
insert into T values('1');
insert into T values('0.8');
帮我把“中国”过滤掉
(
vs clob
)
insert into T values('中国');
insert into T values('0.5');
insert into T values('1');
insert into T values('0.8');
帮我把“中国”过滤掉
length(vs)=lengthb(vs)之类的,但这个函数对clob字段不支持,所以想向大家请教
SELECT * FROM T WHERE DBMS_LOB.INSTR(T.vs,'中国',1,1)>0;
insert into T values('德国');
insert into T values('这是汉字');
insert into T values('这行也要过滤');
反正不是汉字就过滤,请问该怎么做呢
--结果
DBMS_LOB.SUBSTR(VS)
1 0.5
2 1
3 0.8
select dbms_lob.substr(vs) from t where lengthb(dbms_lob.substr(vs))<>length(dbms_lob.substr(vs));