Old SQL History in Oracle SQL Developer

oracle oracle-sqldeveloper
user3035077 picture user3035077 · Sep 12, 2014 · Viewed 70.8k times · Source

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.

Answer

Patrick Bacon picture Patrick Bacon · Sep 12, 2014

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:

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:

My SQL History folder

I do not see any documentation to adjust the size of either.

Related questions

How to export query result to csv in Oracle SQL Developer?

I'm using Oracle SQL Developer 3.0. Trying to figure out how to export a query result to a text file (preferably CSV). Right clicking on the query results window doesn't give me any export options.

Read More
Changing password with Oracle SQL Developer

Many of my users do not use SQLPlus. I cannot give them alter user. We expire passwords every 60 days. I can't get the SQLPlus command "password" to work in SQL developer. When I hit run, I get an invalid command …

Read More
How to generate an entity-relationship (ER) diagram using Oracle SQL Developer

I want to use Oracle SQL Developer to generate an ER diagram for my DB tables but I am new to Oracle and this tool. What is the process for creating an ER diagram in SQL Developer?

Read More