troubleshooting Question

c# - Oracle 11.2 - insert html into column

Avatar of Jeff Fillegar
Jeff FillegarFlag for United States of America asked on
Oracle DatabaseC#
13 Comments1 Solution1629 ViewsLast Modified:
c# - Oracle 11.2 - store html in column.

What is the recommended column type when storing html?

html files > 100K

Snapshot example html (obvisouly not 100K):
<html>
  <body>
    <table width='100%'>
      <tr>
        <td colspan='2' align='center'><b>Legend:</b>
          <font style='background-color: yellow' color='black'>added
          </font>&nbsp;&nbsp;
          <font style='background-color: red' color='black'>removed
          </font>&nbsp;&nbsp;
          <font style='background-color: lightgreen' color='black'>changed
          </font>&nbsp;&nbsp;
          <font style='background-color: red' color='blue'>moved from
          </font>&nbsp;&nbsp;
          <font style='background-color: yellow' color='blue'>moved to
          </font>&nbsp;&nbsp;
          <font style='background-color: white' color='#AAAAAA'>ignored
          </font></td>
      </tr>
      <tr><td><b> File Name : 20120507T094230.xml</b></td>
      </tr>
      <tr>
        <td style="padding-left: 10pt;">
          <font style="background-color: white" color="black">&lt;Envelope
          </font>
          <font style="background-color: white" color="black">xmlns:p1="http://www.w3.org/2001/XMLSchema-instance"
          </font><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <font style="background-color: white" color="black">xmlns="http://schemas.xmlsoap.org/soap/envelope/"
          </font>
          <font style="background-color: white" color="black">&gt;
          </font></td>
        <td style="padding-left: 10pt;">
          <font style="background-color: white" color="black">&lt;Envelope
          </font>
          <font style="background-color: white" color="black">xmlns:p1="http://www.w3.org/2001/XMLSchema-instance"
          </font><br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <font style="background-color: white" color="black">xmlns="http://schemas.xmlsoap.org/soap/envelope/"
          </font>
          <font style="background-color: white" color="black">&gt;
          </font></td>
      </tr>
      <tr>
        <td style="padding-left: 25pt;">
          <font style="background-color: white" color="black">&lt;Body
          </font>
          <font style="background-color: white" color="black">&gt;
          </font></td>
        <td style="padding-left: 25pt;">
          <font style="background-color: white" color="black">&lt;Body
          </font>
          <font style="background-color: white" color="black">&gt;
          </font></td>
      </tr>        
    </table>
  </body>
</html>

Can I store this in XMLType?  I can view the contents of XMLTYPE using SQLDeveloper vs Clob\Blob.

Thoughts?

Thanks in advance.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros