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" <ORACLE-L_at_fatcity.com> 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:jonathan@gennick.com
>
> 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 Oracle-article-request_at_gennick.com 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: jonathan_at_gennick.com
>
> 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: 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.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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