Re: buffer:

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