Viewing text (or optimized text) for an SQL statement

Use the SQL Text window to view the text for an SQL statement, or use the Optimized SQL Text window to view the text for an SQL statement that was rewritten by the optimizer.

Fields and controls

Authorities and privileges

To view text for an SQL statement:

1. Do one of the following:
   • Open the SQL Text window.
   • Open the Optimized SQL Text window.

2. Use the push buttons to copy text, save as, find, or print the SQL text that is displayed in the SQL text box.

Note:

• Null characters are stripped out and do not appear in the window.

• Unreadable characters are represented by a period (.).

• For SQL text that is rewritten by the optimizer, character literals are truncated to 100 characters, and graphic literals are not shown.

• The text is an approximation of the text that was actually used by the optimizer.

Related information

• Finding character strings
• Creating an access plan graph
• Viewing explainable statements for a package
• Viewing the history of previously explained SQL statements
• Viewing a graphical representation of an access plan
• Using Visual Explain windows and notebook