Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Command History in SQL*PLUS
KIrti,
That looks useful for svrmgrl but in sqlplus it shows the password as it is being typed in
(ok if you use sqlplus internal I suppose).
Is there any fix to that.
Is there an alternative to ied for other flavours of Unix (ied does not exist on Tru64 at least)
JOhn
-----Original Message-----
From: Deshpande, Kirti [mailto:kirti.deshpande_at_verizon.com]
Sent: 18 July 01 21:07
To: Multiple recipients of list ORACLE-L
Subject: 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.
> -----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). ********************************************************************** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **********************************************************************Received on Thu Jul 19 2001 - 02:12:27 CDT