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

In article <ks.126.03ED2679_at_ic.uva.nl>, ks_at_ic.uva.nl (Karel Sprenger) wrote:

> 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.
>

 [snip]

If you're using a unix box running your oracle then you can change the editor for ALL users by adding the line
define _editor=/your/path/to/your/editor into the glogin.sql file. This file is located in the $ORACLE_HOME/sqlplus/admin directory. An individual user then can overwrite this by defining his own editor in his private login.sql file (in his home directory).

Hope this helps also
LM

-- 
Leo Mannhart
Planning Office
University of Zurich                phone: ++41 1 257 23 34
Kuenstlergasse 15                     fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland         eMail: mannhart_at_zuv.unizh.ch