Change default EDITor in SQL*Plus

[dmitri]

Who knows how to change the default editor for EDIT command?

[moff]

Hi,

You need to make entry an entry in the sqlplus global login file.
This file is normally found in $ORACLE_HOME\sqlplus\admin
Its name is : glogin.sql
Add any line to this file that you want to be default for SQL*PLUS
eg to make the unix editor 'vi' the default for SQL add the following line

def _EDITOR=vi

Next time you enter sqlplus and type 'ed' the 'vi' editor should start.

You can also put 'set' commands in this file - so if you want to change
the default lines per page for add the line set pagesize 25.

Hope this helps.....

Moff

[dmitri]

WOW! This is realy cool! And it realy works! Thanks! VI is so much better!!! btw in def_EDITOR no spaces needed after 'def'.

Thanks!