可以使用SQL update更新CLOB列的html数据吗?

我有HTML代码，我需要在一个clob列更新，我怎么能在SQL更新字符串转换它?我的第二个问题是如何插入®和&

<html>
<head>
<style></style>
</head>
<body>
<div>
<div align="center" style="font-size:11pt;font-family:Calibri,sans-serif;">
<b> card<sup><font size='3'>&reg;</font></sup>  Card  Notification</b>
<br />
</div>
<hr />
<p style="font-size:11pt;font-family:Calibri,sans-serif;">
The online statement for your  card provided by {company name} and issued by Com is now available. Select the Account Maint. &amp; Statement tab to view your statement.
</p>
<p style="font-size:10pt;font-family:Calibri,sans-serif;">
Equal Opportunity Lender.
</p>
<p style="font-size:10pt;font-family:Calibri,sans-serif;">
This Card is issued  International Incorporated.
</p>
</div>
</body>
</html>

一个选择是使用quotation。如果使用sqlplus

set define off
update my table 
set my_clob_column = q'[ <html>
<head>
<style></style>
</head>
<body>
<div>
<div align="center" style="font-size:11pt;font-family:Calibri,sans-serif;">
<b> card<sup><font size='3'>&reg;</font></sup>  Card  Notification</b>
<br />
</div>
<hr />
<p style="font-size:11pt;font-family:Calibri,sans-serif;">
The online statement for your  card provided by {company name} and issued by Com is now available. Select the Account Maint. &amp; Statement tab to view your statement.
</p>
<p style="font-size:10pt;font-family:Calibri,sans-serif;">
Equal Opportunity Lender.
</p>
<p style="font-size:10pt;font-family:Calibri,sans-serif;">
This Card is issued  International Incorporated.
</p>
</div>
</body>
</html>  ]' 
where ...........

相关内容

最新更新

热门标签：