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: <Jared.Still_at_radisys.com>
Date: Wed, 24 Sep 2003 17:09:40 -0800
Message-ID: <F001.005D0F6A.20030924170940@fatcity.com>


Yes, that was the point of the script.

I've used it before, Kirti has tried it recently on his systems and it still works.

I had some trouble with it in ksh for Linux, didn't spend much time on it. See the link Kirti provided earlier.

Jared

"Tanel Poder" <tanel.poder.003_at_mail.ee>
Sent by: ml-errors_at_fatcity.com
 09/24/2003 12:49 PM
 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


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

> 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: 
  INET: Jared.Still_at_radisys.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).
Received on Wed Sep 24 2003 - 20:09:40 CDT

Original text of this message

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