Open a Editor from SQL*PLUS

SQL>define_editor=vi    // for UNIX
SQL>define_editor=notepad    //for Windows



SQL>edit    // this would open a vi in Unix


afiedt.buf is the file that would be opened. You can then edit the file with a command\query .


Ensure you put as / as a end of the file


Look out for a file called glogin.sql which would ensure setting is permanent in the system line size or page size