I created a query in the Query Builder, can that query be reused.
The query you build by the Query Builder can be saved as tsm files and reused within the connection that you made it with. You can open tsm files by going to 'File | Open Files.'
It can also be used in Automation with the 'Select to File' icon.
1. From the Automation work pane, drag and drop the 'Select to File' icon from the 'Database Activities Toolbox' to the desired location in 'Toad Automation Script' window
2. Double click on the 'Select to File' you just dropped in
3. Under 'Export | SQL Script', look for the tsm file you created
Â
