Re: sqlplus - windows - ed editor - set to other than notepad

On Wed, 11 Oct 2006 06:40:56 -0700, werwer wrote:

> running ed pops up notepad. I have an alternative editor I'd like to
> use.
> Can you set this? The windows association is already set to
> pull up an editor for .sql files (the suffix I use) Is there an Oracle
> def
> somewhere?
> -Thanks.

You should put 'define _editor="c:\Program Files\vim\gvim.exe"' in the SQL*Plus global login file, which is located in the oracle sub-directory at: %ORACLE_HOME%\sqlplus\admin\glogin.sql

Another way of doing things is to have SQLPATH defined in the environment and login.sql in the SQLPATH. GVIM.EXE can be downloaded from www.vim.org and is the Only Right Editor(TM) on Windows platforms. Be specially aware of Emacs and its ungodly clones. Only heathens and pagans use those.

-- 
http://www.mladen-gogala.com