Viewing HTML and XML data in Interactive SQL

You can view HTML and XML data in Interactive SQL.

To view HTML and XML data (Interactive SQL)

Connect to the database.

Execute a query that returns a result set that contains HTML and XML data.

For example to view a result set that contains HTML, run the following:

select '
<html>
 <head>
  <meta http-equiv=Content-Type content="text/html; charset=windows-1252">
   <title>Tee Shirt</title>
 </head>
 <body lang=EN-US>
  <p>
   <span  style=font-size:10.0pt;font-family:Arial>
   We have improved the design of this perennial favorite. A sleek and technical shirt built for the trail, track, or sidewalk. UPF rating of 50+.
   </span>
  </p>
 </body>
</html>
'

For example to view a result set that contains XML, run the following:

SELECT '<?xml version="1.0" encoding="UTF-8"?>

<parent>
    <children>
        <child name="Tim" />
        <child name="Katie" />
    </children>
</parent>

'

In the result set, select a cell that contains HTML content, click ..., and then choose View in Window.

The Value of Column column-name window appears.
Click Cancel to close the window.

Discuss this page in DocCommentXchange.