Re: Command History in SQL*PLUS

Hey all,

There is also the generic solution to all of these problems:

Use emacs. Esc-X shell. Run sqlplus, or any other command, natively. Use regular emacs editing commands to access your history, copy and paste results into other buffers, search and replace, etc.etc.etc. Even write emacs macros (easy as pie - ctrl-X ( means record, ctrl-x ) means endrecord, ctrl-x e means execute.)

Digital Unix (sorry, Tru64) has emacs preinstalled by default, as does most linuxes, but you may have to get your own build on other platforms. sunfreeware.com is a good place to start for a sunpkg, can anyone else come up with a source for aix, hp/ux, etc?

For those of you worried about bloat, or not having this on every platform, there's also an excellent microemacs, available from jasppa.com. It has the shell feature, but I don't know about macros. It's extremely lightweight, and there are precompiled binaries for most platforms including Windows (!) on the www.jasspa.com website.

Hope this helps,
Paul

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, July 19, 2001 10:05 AM

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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Vallee
  INET: dbalist_at_pythian.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).