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

Home -> Community -> Usenet -> c.d.o.server -> Re: Edit a previous command

Re: Edit a previous command

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 17 Nov 2005 06:25:56 +0100
Message-ID: <205on112t362127fj0fgvtep1kjv0dv5g7@4ax.com>


On 16 Nov 2005 21:14:50 -0800, "milkyway" <d0mufasa_at_hotmail.com> wrote:

>Hello,
>
>Sometimes when I do a query, I make a mistake in typing in some
>characters.
>
>Then I have to do the whole query over and type in everything again ;-(
>
>Is there a way to edit what was previously typed in so that I don't
>have to do this?
>
>TIA
Basic sqlplus editing commands
l to list the query
<n> to go to a specific line number
c/<old text>/<new text> to change a line d to delete a line

works like a charm.

Other than that, just type
ed <return>
and end up in Notepad or (preferably) vi

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Nov 16 2005 - 23:25:56 CST

Original text of this message

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