Put SQL in Note checkbox (Resultset options dialog)

SQL*XL home

When Excel is selected as target for the fetched results, SQL*XL will put the SQL of the query in a note in the upper left cell of the resultset when the checkbox is ticked.

Apart from the benefit of knowing later what SQL was used to fetch the data, the Note can be used to later refresh the data. See the rerun a query technique for details.

See also:

• Resultset options dialog
• Target Excel
• Techniques: Rerun a query