How do you save the SQL query along with the data to an Excel or any file.
After running a query, and the results are displayed in the data grid:
Toad 10.x and above please do:
1. Right click on the Data grid and select "Export Data Set", a popup window will be displayed.
2. Select the file format from dropdown 'Export Format'
3. Select Output File
4. Check 'Include SQL Statement'
5. OK
For Toad 9.x and below please do:
1. Right click on the Data gric and select "Export Data Set", a popup window will be displayed.
2. Select the file format from dropdown 'Export Format'
3. Select Output File
4. Check 'Include SQL Statement'
5. OK
Launching the Excel file will show the SQL statements in a separate tab
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center