Re: "ed" command in SQL*Plus: how to change the editor

Hello,

In article <39s7i9INN8t3_at_life.ai.mit.edu> cracraft_at_quaker-oats.ai.mit.edu (Stuart Cracraft) writes:

>How do I change the Oracle default editor for all users
>used by the "ed" command in SQL*Plus to "emacs -nw".

I simply set the environment variable EDITOR to emacsclient (I have emacs running in server mode) and SQL*Plus nicely calls emacsclient.

A much nicer solution if you're already using emacs is to work the other way around: have emacs call sqlplus for you. This is done with the sqlmode.pl stuff which supports both an sql mode (allowing you to run a script in an emacs buffer through sqlplus and see its resulting output in a second buffer) and the sqlplus command which will start a new buffer and interface with SQL*Plus for you. It's a great thing to have around (although there are a few gotchas). Look it up with the lisp-dir-apropos command and then get it from the emacs library at archive.cis.ohio-state.edu.

Cheers,
Karel

--

Karel Sprenger <ks_at_ic.uva.nl>

Informatiseringscentrum                     | phone: +31-20-525 2302
Universiteit van Amsterdam                  |        +31-20-525 2741
Turfdraagsterpad 9, NL-1012 XT  AMSTERDAM   | fax  : +31-20-525 2084
*** PGP Public Key available on servers *** | home : +31-20-675 0989