I have played enough with toad to know that most files are located in C:\Users\user_name\AppData\Roaming\Quest Software\Toad for Oracle\version_number\User Files. Which file is the recall file? Windows is not being helpful with searching.

See this post [image] Can we recover a deleted "sql recall" recent item? Toad for Oracle Can we recover an "sql recall" recent item that was manually deleted? I.e. using the "Delete selected statement" button. The file is SavedSQL.XML, but the SQL in it is encrypted. …

Do you know why the encrypt that file but not the backup file? Figured they would encrypt both files or neither files.

The SQLText in both files is encrypted.

Also, the SQL isn't exactly encrypted. It's base64 encoded as a means to ensure the SQL will not break XML. A CDATA section would have also been sufficient.

Ahh, good point Mike. So user could use any online Base64Decode website such as https://www.base64decode.org/ to decode it.

This one ~eb9442.tmp. The one that is created when you don't save the things in your editor or when toad crashes.

The Editor backup files are not encoded in base64 because they are simple text files and the contents can exist verbatim without issue. The SQL Recall history file uses base64 encoding because the file is XML and a SQL statement containing <, >, or other special characters will product invalid XML u…

And it would cause some problem if you left the SQL Recall history file as a simple text file also?

Not if we used CDATA. What is your use case here? The SQL Recall history file is a Toad configuration file and using it outside of Toad was not a concern when it was created.

I ran a couple of commands and they did not get added to my recall history. So then I started searching for other commands that I knew I had ran to see if they were also missing from my recall history.

Recall history file

Toad for Oracle & DevOps Toolkit

JohnDorlon December 11, 2024, 1:33pm 2

See this post

The file is SavedSQL.XML, but the SQL in it is encrypted.

Topic		Replies	Views
SQL Recall stopped working Toad for Oracle & DevOps Toolkit	7	2242	December 13, 2013
Toad's recall (F8) is empty after restarting Toad Toad for Oracle & DevOps Toolkit	0	432	August 31, 2011
Can we recover a deleted "sql recall" recent item? Toad for Oracle & DevOps Toolkit	2	138	December 10, 2024
SQL Recall statements - saved where? Toad for Oracle & DevOps Toolkit	5	5011	February 22, 2019
Moving sql recall history to new machine Toad for Oracle & DevOps Toolkit	3	2443	March 19, 2014

Recall history file

Related topics