替换字符的问题

[taotie1225]

字段名OCONTENT VARCHAR2(2000)
select ocontent as 选项,replace(ocontent,'<div>','') as 选项1,replace(ocontent,'</div>','') as 选项2 出现以下结果

<div>A.很好</div> A.很好</div> <div>A.很好

目标要把<div>和</div>都替换掉，得出
A.很好
这个结果，怎么写，立马结贴

[Andy__Huang]

select ocontent as 选项,replace(replace(ocontent,' <div>',''),'</div>','') as 选项1
from tb;

[oracledbalgtu]

SELECT OCONTENT AS 选项,
       REPLACE(REPLACE(OCONTENT, '</div>', ''), '<div>', '') AS 选项3
  FROM T;

[Quote=引用楼主 taotie1225 的帖子:]
字段名OCONTENT VARCHAR2(2000)
select ocontent as 选项,replace(ocontent,' <div>','') as 选项1,replace(ocontent,' </div>','') as 选项2 出现以下结果

<div>A.很好 </div> A.很好 </div> <div>A.很好

目标要把 <div>和 </div>都替换掉，得出
A.很好
这个结果，怎么写，立马结贴
[/Quote]

[Andy__Huang]

要替换两次,如果只要一个结果值:
select replace(replace(ocontent,' <div>',''),' </div>','') as 选项
from tb;

[taotie1225]

select replace(replace(ocontent,' <div>',''),' </div>','') as 33
as后面跟数字为什么就不行了？

[Andy__Huang]

[Quote=引用 4 楼 taotie1225 的回复:]
select replace(replace(ocontent,' <div>',''),' </div>','') as 33
as后面跟数字为什么就不行了？
[/Quote]

要加双引号
select replace(replace(ocontent,' <div>',''),' </div>','') as "33"

[zcs_1]

Oracle10g用正则表达式

select regexp_replace(ocontent,'(<)(/)?(div>)','') from t