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