Backup editor files

Toad for Oracle
1

Hello,

Is there a way to backup all executed sql in backup files. I have tried to use SQL recall but it does not display all executed sql (F5 + F9). I can also find it in the roaming directories UserFiles. I also set the backup editor to 3 minutes but it disappears after logging out without saving. Maybe there is a setting to always store editor windows.

Regards,
Rob

2

If you want to capture all of the SQL that Toad executes, you can use main menu -> Spool SQL -> Spool to file (or spool to screen) but that will also include things that Toad does in the background.

There is no way to just capture your F5 and F9 SQL and nothing else.

Edit: I guess you could include a "Spool" command in your scripts to run with F5. Then you could have that and SQL Recall.