RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.

I use SQL*Plus running under emacs shell every day. It is my preferred way of:

• Recording my sqlplus sessions so I can go back and search to see what I did
• having an up-arrow comand history capability
• Having line editing capability
• editing SQL scripts in the same window where I am running
• everything else

I came to prefer emacs because it has capabilities far in excess of vi or any other unix editor. Because it is open source software, many people have contributed over the years, making the package extremely powerful. Also, I started on Vax/VMS edt and eve/tpu, which are more like emacs than vi.

There is an emacs OracleSQL mode, but I don't use it. I just start emacs, META-X shell, then sqlplus...

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Fri, 25 Jul 2003, Orr, Steve wrote:



> I agree with the developer vs. sysadmin generalization but this was not

> meant to be a post about favorite editors... It's about whether anyone

> has used or seen a SQLPlus "shell" running under emacs. Has anyone

> "witnessed" SQLPlus running under a well-configured emacs session and

> have impressions to share?

> 

> The statistics I've heard are that 9 out of 10 SysAdmin/DBA's use vi. I

> wonder what the breakdown is for Linux admins? Since emacs is easy to

> implement I could see it gaining ground on Linux but sometimes old

> dinosaur type SysAdmins are slow to evolve. :-)