SQL Developer

I came across some blog entries about Macro Record and Macro Play functionality in JDeveloper and wondered if it worked for SQL Developer as well. Sure enough it does. This is great!!

http://groundside.com/blog/DuncanMills?title=well_you_learn_something_new&more=1&c=1&tb=1&pb=1
http://thepeninsulasedge.com/blog/2006/11/07/jdeveloper-recording-and-playing-back-macros/

To define accelerators for recording and playing back:

1. From the main menu, choose Tools then choose Preferences.
2. In the Preferences dialog, select the Accelerators node.
3. On the Accelerators page, in the Category list select Code Editor.
4. In the Actions list, select Macro Toggle Recording.
5. Put the focus in the New Accelerator field, and enter an accelerator by pressing the key combination on the keyboard.
6. To add the accelerator you have suggested for beginning and ending the recording of macros, click Add
7. Now, in the Actions list, select Macro Playback.
8. Repeat steps 5 and 6 to assign an accelerator for playing back the macro.
9. Click OK.

To record a macro:

1. Open the source file in an editor.
2. To begin recording, press the key combination you have defined for recording macros.
3. Now enter the keystroke sequence you wish to record.
4. To end recording, again press the key combination you have defined for recording macros.

To play back a macro:

1. Open the source file in an editor.
2. Position your cursor in the open file.
3. Press the key combination you have defined for playing back macros.


Michael A. Rife