Previous Topic

Next Topic

Book Contents

Book Index

Displaying XML Values

In This Chapter

Displaying Formatted XML

XML Viewer

View XML in Grid

XML data is generally held as large text values, using the data types of CLOB, Long Varchar or XML.

To display the full value of these fields, you need to either have a high value of Max Column Size, or use the Write LOBs to Files option. This is discussed in more detail in Displaying Large Text Values.

We recommend the use of Write LOBs to files, as in the example below.

To see the full XML value, double-click the grid value, or right-click and select View.

Displaying XML values

The Detail window provides a number of different ways of viewing the XML value. These options are also available on the View menu.

These are described in the following sections.

XML View options

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.