RE: Command History in SQL*PLUS

On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH)
Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things.

On NT, I guess use your arrow keys... (Not sure of that, though)..

HTH, Regards.

• Kirti Deshpande Verizon Information Services http://www.superpages.com

> -----Original Message-----
> From: Rama Malladi [SMTP:rama_at_toyota.com]
> Sent: Wednesday, July 18, 2001 2:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Command History in SQL*PLUS
>
> Sometime ago there was a post on how to get the last commands executed
> in SQL*Plus. It is very similar to doing escape from the UNIX command
> line....
>
> Do you know how to scroll down the last 10-20 commands executed in
> SQL*Plus ? I am not talking about "/" which would get the last command.
>
> Rama
>
> --

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).