Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Edit a previous command
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 DBAReceived on Wed Nov 16 2005 - 23:25:56 CST