| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re[2]: 10g: SQL Plus
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
 |
 |