Re: Can't edit in sqlplus

  • From: "David Sharples" <davidsharples@xxxxxxxxx>
  • To: sbecker6925@xxxxxxxxx
  • Date: Fri, 10 Nov 2006 14:57:15 +0000

have this in your login.sql

define_editor=vi

or

export EDITOR=vi  in your linux profile


On 10/11/06, Sandra Becker <sbecker6925@xxxxxxxxx> 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


Other related posts: