Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sqlplus - windows - ed editor - set to other than notepad

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

From: Arto Viitanen <arto.viitanen_at_csc.fi>
Date: Thu, 12 Oct 2006 09:01:55 +0300
Message-ID: <452dda51$0$8959$ba624cd0@newsread.funet.fi>


Mladen Gogala wrote:
> 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
>

Or, you could install XEmacs, and run M-x sql-oracle, which runs sqlplus inside Emacs. That way you have your whole session inside the Emacs buffer, so you can copy previous queries, use parts of the result in WHERE condition etc.

-- 
Arto Viitanen,  CSC Ltd.
Espoo, Finland
Received on Thu Oct 12 2006 - 01:01:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US