Hi,

To set the editor for editing sql commands and PL/SQL code at the SQL*Plus (Unix: $sqlplus) enter the following command at ur sql prompt after logging in

define _editor = <path and file name of the exe for the new editor>

Hope this solves ur prob

Cheers,

Guna Sagar Challa

For time being type below command at sql prompt

SQL>define_editor=vi

You can add export EDITOR=vi in .profile and logou/login for permament change

Hope this will solve it