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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Can't edit in sqlplus

Re: Can't edit in sqlplus

From: David Sharples <davidsharples_at_gmail.com>
Date: Fri, 10 Nov 2006 14:57:15 +0000
Message-ID: <be592d550611100657o23b42e73v5e01adf689e8d47e@mail.gmail.com>


have this in your login.sql

define_editor=vi

or

export EDITOR=vi in your linux profile

On 10/11/06, Sandra Becker <sbecker6925_at_gmail.com> wrote:
>
> One of the problems I've encountered is editing while in sqlplus. I
> copied my .bash_profile and .bashrc files from the current production node
> and made the appropriate changes since I made the ORACLE_HOME a more generic
> name. (was 9.2.0.4.0, made it 920)
>
> I key in my query and after I get the results I want to change something
> in the query so I type in edit. What I get back is the following:
>
> Wrote file /u01/app/oracle/product/920/rdbms/admin/afiedt.buf
> 277
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 10 2006 - 08:57:15 CST

Original text of this message

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