It's possible to use the Spool SQL option to show the log of the script ran.
Spool SQL shows all the statements that Toad runs in the background, this will include the scripts that a user runs. Send the statements to a window in Toad or save them to a file. The file is call Debug.sql in the directory (C:\USER\<USER_NAME>\APPDATA\ROAMING\QUEST SOFTWARE\TOAD FOR ORACLE\USER FILES\DEBUG.SQL).
To turn the log on:
1. Select menu Database | Spool SQL and where you want to send the code.
2. Select Spool SQL for file.
