"Previous SQL" and "Next SQL" functionality enhancement?

[zitot]

I finally figured out what these buttons are for, you can 'revert' the SQL Window to a previously run sql command within. It's good if you're actively working on the code, but is there a way to see all the versions in a SQL window that were used and pick from that instead? At least I don't have to scroll down or switch tabs anymore, this is better way of doing it..

ill summarize what I know:

1. The SQL command history is local to a tab
2. If you close the tab and reopen it, the tab history is gone.
2.a. If you close PLSQL Developer and reopen it, everything's history is gone, even though you technically didn't close the tab.
3. If you logoff and log back on, as long as the tab was not closed, the history persists
4. (lets say there's N number of SQL history in the window). If you go back to a previous version N-2, edit and run, it doesn't overwrite the version at N-1 and N, but pushes a new version at position N+1.
5. Not a replacement for version history :grin:
6. If you don't know about CTRL+UP/Down hotkey, I lost my tab a couple times not knowing why data was suddenly different or the file was empty until i looked in the hotkey

questions
is there a file that is already storing the tab history on disk somewhere as plain text that we can access ourselves just to look at instead of blind up/up/down/down?
Did I miss an option that would show me all history on a tab? I don't see any on SQL Window section of key configuration, though

 

[Marco Kalter]

You can use the "Edit > Recall Statement" function for this. By default the Ctrl-E function key is assigned to it. It will show all executed commands for a connection, or for all connections. You can use a filter to find statements. Right-click on the statement list for more options.

 

[Megar]

Yeah, I ran into the same confusion at first. The "Recall Statement" thing is actually super helpful once you get used to it. It’s not perfect, but at least it shows more than just what you scroll through with Ctrl+Up/Down. I don’t think there’s a plain text file with the tab history, though, seems like it’s all stored in memory while the session is alive.