ProjectSMM.com
Gonzo TechNet
Oracle SQL Server: Tips, Tricks, & How-To's
How to set the SQLPLUS editor to something other than Notepad.exe on windows
You can modify a number of setting for the way SQL*PLUS (gui & command line) acts through the settings contained in the file:
$ORACLE_HOME\Product\\client_X\sqlplus\admin\glogin.sql
C:\oracle\product\10.2.0\client_1\sqlplus\admin\glogin.sql
See this link on SET for more info. http://ora.u440.com/sqlplus/set.html
To set the Oracle editor to VIM (vi), add the following to your glogin.sql
--Set VIM as the Editor (instead of Notepad.exe)
--DEFINE _EDITOR='gvim -c "set filetype=sql"'
DEFINE _EDITOR='vim -c "set filetype=sql"'
--Set the width of query output (For DOS window/etc)
SET LINESIZE 150