Oracle:查找并替换varchar字段中的html实体

Question

我试图找到一个varchar字段内的html实体(例如& uml;):

set define off;
SELECT description FROM descriptions WHERE contains(description, 'ü') > 0;
SELECT description FROM descriptions WHERE contains(description, '&uuml') > 0;
SELECT description FROM descriptions WHERE contains(description, '%uuml%') > 0;
set define off;
set escape on;
SELECT description FROM descriptions WHERE contains(description, 'ü') > 0;
SELECT description FROM descriptions WHERE contains(description, '&uuml') > 0;
SELECT description FROM descriptions WHERE contains(description, 'ü') > 0;

没有一个查询正在工作，尽管有很多潜在的结果。什么好主意吗?很多谢谢!

Answer 1

您是否在description上定义了Oracle Text索引?如果是，你是如何定义这个索引的?加载数据后是否重新同步了索引?

如果你使用INSTR而不是CONTAINS，你会得到结果吗?

SELECT description 
  FROM descriptions 
 WHERE instr(description, 'ü') > 0;