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" <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
> 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:[EMAIL PROTECTED]>]
> 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:[EMAIL PROTECTED]]
> > 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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
