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

Home -> Community -> Usenet -> c.d.o.misc -> Re: buffer:

Re: buffer:

From: John P. Higgins <jh33378_at_deere.com>
Date: Fri, 25 Dec 1998 15:20:59 -0600
Message-ID: <368401BB.A2130E6F@deere.com>


I assume you are using SQL*Plus. If so, try this:

define _editor=vi
or
define _editor=C:\WINDOWS\notepad.exe

The underscore is part of the name, _editor and MUST be included.

This command must be repeated in every SQL*Plus session (unless you put it into a special script, login.sql).

Then, in SQL*Plus, you can enter the edit command. SQL*Plus writes its buffer into a temp file and jumps out to an editor session for your editing pleasure. When you save and exit the editor, SQL*Plus grabs the edited file back into its buffer. You can execute the command by typing /.

HTH christoph erdt wrote:

> I am a beginner in SQL and like to know how to acces the buffer in
> order to correct typing mistakes after I jump several lines down in
> code . Now I have to retype it all from the beginning (first line)
> Cannot use the mouse to edit code and go back and undo, is there any
> way to anable it -please give me some advice.....tks
Received on Fri Dec 25 1998 - 15:20:59 CST

Original text of this message

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