oracle blob文本搜索 [英] oracle blob text search
本文介绍了oracle blob文本搜索的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
是否可以使用sql语句搜索Blob文本? 我可以从$ table中选择*,如果f1是varchar,f1就像'%foo%',f1是一个blob呢?有什么对应的吗?
Is it possible to search through blob text using sql statement? I can do select * from $table where f1 like '%foo%' if the f1 is varchar, how about f1 is a blob? Any counter part for this?
推荐答案
这是完全可能且容易实现的.
This is quite possible and easy to do.
只需将dbms_lob.instr与utl_raw.cast_to_raw结合使用
Simply use dbms_lob.instr in conjunction with utl_raw.cast_to_raw
因此,在您的情况下,如果t1是BLOB,则选择将如下所示:
So in your case, if t1 is a BLOB the select would look like:
select *
from table1
where dbms_lob.instr (t1, -- the blob
utl_raw.cast_to_raw ('foo'), -- the search string cast to raw
1, -- where to start. i.e. offset
1 -- Which occurrance i.e. 1=first
) > 0 -- location of occurrence. Here I don't care. Just find any
;
这篇关于oracle blob文本搜索的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文