Can we update html data of CLOB column by using SQL update?

Question

i have html code which i need to update in one clob column , how can i convert it in sql update string? My second question is that how to insert ® and & which exist in this html code.

<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>

Roberto Hernandez · Accepted Answer · 2021-10-25 13:08:00Z

1

One option would be to use quotation. If you use 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 ...........

edited Oct 25, 2021 at 13:08

answered Oct 25, 2021 at 12:02

Roberto Hernandez

8,5933 gold badges22 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

vim Over a year ago

yeah this is the way to get the solution, just one thing need to ask that how to handle & ® .Your solution is working but only need to insert & ®, that is there in html code..do you know that?

Roberto Hernandez Over a year ago

if you use sqlplus, then use set define off. I updated the post

William Robertson Over a year ago

@vim then this is a Toad question. It must have a way to disable substitution variables or to use a different character. Top hit: support.quest.com/toad-for-oracle/kb/11560/…

Roberto Hernandez Over a year ago

@vim, you can use Toad the same, but run it as script ( F5 )

Roberto Hernandez Over a year ago

@vim, you are very welcome. glad that it helped.

|

Collectives™ on Stack Overflow

Can we update html data of CLOB column by using SQL update?

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related