Question

I have a table having one clob column which has XML data in it. Say I want to replace XYZ with ABC in the clob column. Is it possible using sqlplus?

Answer 1

"i have new line in the column. any advice?"

新路线是属性的;如果你想要修正载有新内容的案文,你需要将这些内容列入搜索范围。你们可以通过将ASCII作为论据的价值的人权中心这样做。您需要列入的准确编码根据职业介绍所的不同而有所不同。因为我在管理系统Windows I上就这样作,所以需要通过双轨(ASCII=10)和回程(ASCII=13)。

SQL> select * from t42
  2  /

TXT
--------------------------------------------------------------------------------
<ABC> ABCD
  </ABC>


SQL>  update t42 set txt=replace(txt, ABCD ||chr(10)||chr(13),  APC woz here )
  2  /

1 row updated.

SQL> select * from t42
  2  /

TXT
--------------------------------------------------------------------------------
<ABC> APC woz here </ABC>

SQL>

顺便说一句,如果你储存XML文本,则可能值得使用XMLType数据类型,而不是CLOB。它有许多有用的功能。

Answer 2

为什么不尝试?

SQL> create table nnn(c1 clob);

Table created.

SQL> insert into nnn values ( text ABC end );

1 row created.

SQL> select * from nnn;

C1
-------------------------------------------------
text ABC end

SQL> update nnn set c1=replace(c1, ABC , XYZ );

1 row updated.

SQL> select * from nnn;

C1
-------------------------------------------------
text XYZ end

SQL>

Answer 3

是的,它有可能发挥一种REPLACE的功能。 Try:

update nnn set c1 = REPLACE(c1, ABC> , XYZ> )

友情链接