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.

Discuter à propos de cette page dans DocCommentXchange.