我有 html 代碼需要在一個 clob 列中更新，我如何將其轉換為 sql 更新字串？我的第二個問題是如何插入此 html 代碼中存在的 ? 和 & 。
<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'>®</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. & 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>
uj5u.com熱心網友回復：
一種選擇是使用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'>®</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. & 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 ...........
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/336355.html
下一篇：如何在Oracle中將`(Ab56.12345)some_string`的一列字串拆分為兩列`Ab.12345`、`some_string`