Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 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
![]() |
![]() |