Using vi in sqlplus for editing.

Editing in sqlplus.

Enter following command in sqlplus for using VI as an editor.

define_editor='vi'

If you want to make it permanent add the above line to following file.

$ORACLE_HOME/sqlplus/admin/glogin.sql