RE: Command History in SQL*PLUS

John,
Yes, thanks for pointing that out. The password will be displayed when using 'ied'. I have not found any solution to that, and the way 'ied' works I doubt if there is any workaround. Sorry. The script I mentioned will suppress the password, but I think it will be displayed when recalling previous commands. I do not know if there is anything like 'ied' on Sun or AIX or any other UNIX flavour.

Thanks.

• Kirti

> -----Original Message-----
> From: Hallas John [SMTP:John.Hallas_at_btcellnet.net]
> Sent: Thursday, July 19, 2001 3:10 AM
> To: Multiple recipients of list ORACLE-L
> Subject: 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.
>
> - 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).