Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: 10g: SQL Plus

Re: Re[2]: 10g: SQL Plus

From: Tanel Poder <tanel.poder.003_at_mail.ee>
Date: Wed, 24 Sep 2003 11:49:47 -0800
Message-ID: <F001.005D0F30.20030924114947@fatcity.com>


Does it work even in sqlplus?

Tanel.

  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" <tanel.poder.003_at_mail.ee> 
        Sent by: ml-errors_at_fatcity.com 
         09/24/2003 09:44 AM 
         Please respond to ORACLE-L 

               
                To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 
                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

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

> 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).
-- 
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).
Received on Wed Sep 24 2003 - 14:49:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US