Friday, April 16, 2010

SQL Developer History

SQL Developer History
History of commands is handled very well in SQLDeveloper. Pressing F8 will display the history of sql commands that has been issued till now. Place the cursor in the SQL Window, and press "Ctrl+Up arrow" or "Ctrl + down arrow", to paste commands in the history tab into the SQL Window. This works very well, except for the last row or the first row, when the up or down arrow will takes me nowhere. For either of these two situations, I either grab the SQL, from the History window, with cursor and drop it in the SQL Window; or, go down/up a row in the History window and press the "Ctrl+Up" or Ctrl+dwn" key.

2 comments:

Steven said...

what do you do if none of these things works? I'm using 1.5.4, and the history window just sits there - Ctrl-arrow does nothing, drag-n-drop doesn't work, Ctrl-C (copy) doesn't - it's very frustrating to see the old commands there but no to be able to do anything with them.

Srini said...

Then it is time to do an upgrade. Just download the latest SQLDeveloper from otn and unzip into a new directory. Check whether everything works out as expected.
I am sure this problem will be resolved.