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: recall/edit commands

Re: recall/edit commands

From: Dave Wotton <Dave.Wotton_at_dwotton.nospam.clara.co.uk>
Date: Mon, 11 Sep 2000 14:01:17 +0100
Message-ID: <8C4v5.15306$%t6.1156502@nnrp3.clara.net>

Legend wrote in message ...
>Is it possible to recall a previous command to execute again or recall a
>previous command to edit and then execute in a sqlplus/svrmgrl session?

SQL*Plus does not have a command history facility. You can edit and re-execute the previously issued command, as explained in the other posts, but that's all.

One feature not explained in the other posts is that if you invoke the SQL*Plus command "ed", it invokes your system editor to edit the command. If you're running client/server on Windows, that'll be notepad. If you're running on Unix, it is configurable using (I think, I'm not on Unix at the moment) the "editor = ....." command in your login.sql file. It defaults to the (not very useful) Unix "ed" editor, but most people change it to vi or emacs etc.

Very useful if you've got a large multi-line select in your edit buffer.

Dave.

--
If you reply to this posting by email, remove the "nospam" from my email
address first.
Received on Mon Sep 11 2000 - 08:01:17 CDT

Original text of this message

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