Old SQL History in Oracle SQL Developer
As Oracle has documented, there is a SQL history folder and it is larger (has more SQL queries that go back about a year) than the SQL History tool bar (a couple of months).
Here is the content of my SQL History tool bar:
With respect to the SQL history folder, release notes cite this location in Windows 7:
C:\Users\your_user_name\AppData\Roaming\SQL Developer\SqlHistory
While this folder contains SQL History, it also contains: User-defined reports and user-defined snippets files (e.g. see 3.1 Sql Developer release notes) Here is my SQL History folder:
I do not see any documentation to adjust the size of either.
In SQL Developer, to change the limit go to:
Tools -> Preferences
.
Inside this, navigate to:
Database –> Worksheet –> SQL History Limit
Change it to whatever you want. (In 4.0.1.14, the max was 999999999.)
Hope it helps.
Best regards.
Well, I think there is another option like this:
In SQL Developer> View menu:
Then, go to file option:
and you got recent file tab:
You can try
View > History SQL
For example, look this picture: