Menu
In SQL Developer, i was finding some SQL commands of previous month but not able to find that as it is showing only the records of last 4-5 days.
Is there any way to find the old SQL commands those are not displaying under SQL history tab.
Thanks.
959
Create a backup copy of the folder or directory where your SQL Developer user information is stored, in case you want to restore any old user-defined reports, snippets, code templates, or SQL history. The default location is: Windows: C:\Documents and Settings\<user-name>\Application Data\SQL Developer.
View > History SQL In SQL Developer, to change the limit go to: Tools -> Preferences . Change it to whatever you want.
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.
190
You can try
View > History SQL
For example, look this picture:
26
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
