# Recover Sql Recall History

**URL:** <https://forums.toadworld.com/t/recover-sql-recall-history/45141>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [January 4, 2019, 5:55pm UTC](https://forums.toadworld.com/t/recover-sql-recall-history/45141 "2019-01-04T17:55:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lthornto](https://avatars.discourse-cdn.com/v4/letter/l/bbce88/32.png) [@lthornto](https://forums.toadworld.com/u/lthornto)\
**Post date:** [January 4, 2019, 5:55pm UTC](https://forums.toadworld.com/t/recover-sql-recall-history/45141/1 "2019-01-04T17:55:58Z")

</div>

I am using Toad for Oracle 12.12.0.39. I had SQL Recall set to save 500 queries. I need to recover a sql prior to the earliest one that is returned. Is this possible? If so, how to I go about it?  
Thanks in advance

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [January 4, 2019, 6:06pm UTC](https://forums.toadworld.com/t/recover-sql-recall-history/45141/2 "2019-01-04T18:06:39Z")

</div>

This isn’t possible. SQL Recall will only store up to the 500 entries you’ve specified. When a new item is added if the number of statements is already at 500 then the oldest statement is purged, permanently.

---

<div class="post-metadata">

**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\
**Post date:** [January 7, 2019, 5:19pm UTC](https://forums.toadworld.com/t/recover-sql-recall-history/45141/3 "2019-01-07T17:19:24Z")

</div>

Couple things to think about. Saved SQL (previous Toad versions called this “Named SQL”) are kept in an XML file.

1. If you exported your Saved/Named SQL in the past, the SQL entry you seek may be in that export file.

2. If you upgraded your Toad installation, you may still have a previous SavedSQL.xml file from the older Toad version. Check for it in Toad’s “UserFiles” appdata directory.  
For example, my SavedSQL.XML file is located in this directory (username changed to protect… well…yeah)  
C:\Users\“myuser”\AppData\Roaming\Quest Software\Toad for Oracle\13.1\User Files

Hope this helps.