We execute changes to our application (schema and data) using scripts executed in Toad Editor. These scripts often have multiple SQL statements obviously. We need the ability to keep a record of the whole execution for audit/bug fixing/training reasons etc.
We can look at the Messages tab and perform a Cntl+A on that and paste that, but the statement output in the Results Sets cannot be selected all together to be copied anywhere. I have to click on each row in the result set and manually export it (x 48 times)!
Solution 1 Provide ability to log ALL output from a script to a file, if result set contains data then export each SELECT output as a separate sheet in ONE Excel file.
Solution 2 Provide ability to log ALL output from a script to a file, if result set contains data then export each SELECT output to a separate Excel file.
Solution 3 Provide ability to log ALL output from a script to a file or clipboard, so user can paste it where they choose.
If solution 3 is the fastest (probably is) then go for that please!
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.
© ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center