Hey, finally figured out how to make emacs my sql editor in sqlplus. If (like me) you find the command line interface of SQLPlus on unix a little combersome, with commands like: 5 append ORDER BY foo change/foo/bar And just wish you could pop open a nice editor like the VI integration in MySQL, it's easy. Just use the command: DEFINE _EDITOR="emacs" Now, if you load a lot of stuff in your .emacs file, you might want to use the following command line switch to emacs. DEFINE _EDITOR="emacs --no-init-file" Or if you're on a remote box, you could use: DEFINE _EDITOR="emacs -nw --no-init-file" Anyway you slice it, it pops open an emacs session with your last used SQL command, and then when you C-x,C-c the window, it puts it into your SQL*Plus session where you can use type 'RUN' or '/' to execute it. Supposedly the default editor for SQL*Plus is actually vi, but it looks more like 'ed' to me. Probably just a config problem. :) -Lkb
