This can be done with ksh as well.
Someone else may have a link to the script that a rather
good ksh coder put together and posted here a few
years ago.
Jared
| "Tanel Poder" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 09/24/2003 09:44 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: Re[2]: 10g: SQL Plus |
Hi!
Press F7 in windows command line sqlplus to see history of your sql commands
(it's actually cmd.exe feature). And particularily nice feature is that you
can search the F7 history list, by pressing the first letter of a command ->
you'll be navigate to "alter" command for example if you press "a" in
history list, one more "a" will navigate to previous command starting with
a. Pressing enter will execute the command again, pressing right arrow will
just put the command to prompt where you can edit it before executing.
This is one of the reasons why I'm staying on windows with my desktop :)
Tanel.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 24, 2003 7:29 PM
> Wednesday, September 24, 2003, 11:44:44 AM, you wrote:
> BM> Ive actually began to like sqlplus (opposed to sqlplusw). One good
> BM> feature is you have your command history using the up arrow like
regular
> BM> shell
>
> Scrolling back to see what you've done is a bit more
> problematic, though you can configure a DOS window to retain
> some history. You have to think to configure it first
> though.
>
> Best regards,
>
> Jonathan Gennick --- Brighten the corner where you are
> http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED]
>
> Join the Oracle-article list and receive one
> article on Oracle technologies per month by
> email. To join, visit
http://four.pairlist.net/mailman/listinfo/oracle-article,
> or send email to [EMAIL PROTECTED] and
> include the word "subscribe" in either the subject or body.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jonathan Gennick
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
--
Author: Tanel Poder
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
