Displaying Large Text Values

If your table contains large text values, there are a couple of options that help you display these:

• the amount of data displayed for any value is determined by Options > Display Limits > Max Columns Size. By default this is 1000. If you have large text values you may wish to increase this to a larger value.

  If your data is large than 100K bytes, it is recommended to use the Display LOBs feature.

• select View > Variable Row Height, Ctrl+H or the Height icon. The height of the grid rows will expand to show the full text of the data.
• right-click a cell and select View. This will take you to AQT's Detail of Data Value window.
• you can display the cell contents using a particular application by right-clicking the cell and selecting View As. This is discussed in more detail in Displaying BLOBs and CLOBs.

Detail of a Data Value window

This window shows you the full value of a cell.

Note that if the data contains a hex0 character (x'00') the data will be truncated at that point. This is a limitation of the Windows text box used in this window. The way to avoid this problem, AQT will replace any hex0 characters with a ^ to enable the full value to be displayed.