Subject: RE: Command History in SQL*PLUS
Hi Kirti, fep runs on Linux, Solaris, HP, AIX http://www.peak.org/next/apps/unix/commandline/fep/ Runs in vi or emacs mode, may be other stuff. It is a simple command line wrapper, can be used for other programs also Dave > John, > Yes, thanks for pointing that out. The password will be displayed when using > 'ied'. I have not found any solution to that, and the way 'ied' works I > doubt if there is any workaround. Sorry. > The script I mentioned will suppress the password, but I think it will be > displayed when recalling previous commands. > I do not know if there is anything like 'ied' on Sun or AIX or any other > UNIX flavour. > -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Command History in SQL*PLUS
Hey all, There is also the generic solution to all of these problems: Use emacs. Esc-X shell. Run sqlplus, or any other command, natively. Use regular emacs editing commands to access your history, copy and paste results into other buffers, search and replace, etc.etc.etc. Even write emacs macros (easy as pie - ctrl-X ( means record, ctrl-x ) means endrecord, ctrl-x e means execute.) Digital Unix (sorry, Tru64) has emacs preinstalled by default, as does most linuxes, but you may have to get your own build on other platforms. sunfreeware.com is a good place to start for a sunpkg, can anyone else come up with a source for aix, hp/ux, etc? For those of you worried about bloat, or not having this on every platform, there's also an excellent microemacs, available from jasppa.com. It has the shell feature, but I don't know about macros. It's extremely lightweight, and there are precompiled binaries for most platforms including Windows (!) on the www.jasspa.com website. Hope this helps, Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, July 19, 2001 10:05 AM John, Yes, thanks for pointing that out. The password will be displayed when using 'ied'. I have not found any solution to that, and the way 'ied' works I doubt if there is any workaround. Sorry. The script I mentioned will suppress the password, but I think it will be displayed when recalling previous commands. I do not know if there is anything like 'ied' on Sun or AIX or any other UNIX flavour. Thanks. - Kirti > -Original Message- > From: Hallas John [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 3:10 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Command History in SQL*PLUS > > KIrti, > That looks useful for svrmgrl but in sqlplus it shows the password as it > is being typed in > (ok if you use sqlplus internal I suppose). > Is there any fix to that. > Is there an alternative to ied for other flavours of Unix (ied does not > exist on Tru64 at least) > > JOhn > > -Original Message- > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > Sent: 18 July 01 21:07 > To: Multiple recipients of list ORACLE-L > Subject: RE: Command History in SQL*PLUS > > > On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied > sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set > > -o vi' in a KSH) > Check out a script #10 at <http://www.orafaq.com/faqscrpt.htm#UNIX>. It is > > wrapper for sqlplus and svrmgrl to do similar things. > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > HTH, > > Regards. > > - Kirti Deshpande > Verizon Information Services ><http://www.superpages.com> > > > -Original Message- > > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 2:36 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Command History in SQL*PLUS > > > > Sometime ago there was a post on how to get the last commands executed > > in SQL*Plus. It is very similar to doing escape from the UNIX command > > line > > > > Do you know how to scroll down the last 10-20 commands executed in > > SQL*Plus ? I am not talking about "/" which would get the last command. > > > > Rama > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Command History in SQL*PLUS
John, Yes, thanks for pointing that out. The password will be displayed when using 'ied'. I have not found any solution to that, and the way 'ied' works I doubt if there is any workaround. Sorry. The script I mentioned will suppress the password, but I think it will be displayed when recalling previous commands. I do not know if there is anything like 'ied' on Sun or AIX or any other UNIX flavour. Thanks. - Kirti > -Original Message- > From: Hallas John [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, July 19, 2001 3:10 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Command History in SQL*PLUS > > KIrti, > That looks useful for svrmgrl but in sqlplus it shows the password as it > is being typed in > (ok if you use sqlplus internal I suppose). > Is there any fix to that. > Is there an alternative to ied for other flavours of Unix (ied does not > exist on Tru64 at least) > > JOhn > > -Original Message- > From: Deshpande, Kirti [ <mailto:[EMAIL PROTECTED]>] > Sent: 18 July 01 21:07 > To: Multiple recipients of list ORACLE-L > Subject: RE: Command History in SQL*PLUS > > > On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied > sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set > > -o vi' in a KSH) > Check out a script #10 at <http://www.orafaq.com/faqscrpt.htm#UNIX>. It is > > wrapper for sqlplus and svrmgrl to do similar things. > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > HTH, > > Regards. > > - Kirti Deshpande > Verizon Information Services ><http://www.superpages.com> > > > -Original Message- > > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > > Sent: Wednesday, July 18, 2001 2:36 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Command History in SQL*PLUS > > > > Sometime ago there was a post on how to get the last commands executed > > in SQL*Plus. It is very similar to doing escape from the UNIX command > > line > > > > Do you know how to scroll down the last 10-20 commands executed in > > SQL*Plus ? I am not talking about "/" which would get the last command. > > > > Rama > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Command History in SQL*PLUS
Title: RE: Command History in SQL*PLUS KIrti, That looks useful for svrmgrl but in sqlplus it shows the password as it is being typed in (ok if you use sqlplus internal I suppose). Is there any fix to that. Is there an alternative to ied for other flavours of Unix (ied does not exist on Tru64 at least) JOhn -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: 18 July 01 21:07 To: Multiple recipients of list ORACLE-L Subject: RE: Command History in SQL*PLUS On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH) Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things. On NT, I guess use your arrow keys... (Not sure of that, though).. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Command History in SQL*PLUS > > Sometime ago there was a post on how to get the last commands executed > in SQL*Plus. It is very similar to doing escape from the UNIX command > line > > Do you know how to scroll down the last 10-20 commands executed in > SQL*Plus ? I am not talking about "/" which would get the last command. > > Rama > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. **
Re: Command History in SQL*PLUS
Yosi Greenfield wrote: > > Bill, > > I'm on NT and the up and down arrows work peachy! That's > one of the few things I don't miss about Unix. I didn't think > there was anything additional running on my pc to allow the > arrows to work, but they do for me. Hmm... > > Unless you're referring to the windows client. (I just thought > of this right before clicking 'send.') I use the DOS client in > a cmd window just for this reason. The Windows client doesn't > use the arrow keys, the DOS version does. > > Is that what you meant? yup, sorry i wasn't more specific. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Command History in SQL*PLUS
Try CPAN. There's some free wrappers out there: "MyOracle" emulates MySQL but it's a bit clunky and has bad error handling on exit. "fsql" is written in C and is fast but has very limited login capability. It does not mimic MySQL's show tables command. "YASQL" (Yet another SQL) is also a Perl wrapper but it's not bad. Show tables works and the up arrow is OK. Has good login capability for SQL*Net but it echos passwords to the screen. The best approach is to just get over MySQL addiction and learn to love SQL*Plus with all it's shortcomings. :-) Steve Orr -Original Message- Sent: Wednesday, July 18, 2001 2:07 PM To: Multiple recipients of list ORACLE-L On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH) Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things. On NT, I guess use your arrow keys... (Not sure of that, though).. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Command History in SQL*PLUS > > Sometime ago there was a post on how to get the last commands executed > in SQL*Plus. It is very similar to doing escape from the UNIX command > line > > Do you know how to scroll down the last 10-20 commands executed in > SQL*Plus ? I am not talking about "/" which would get the last command. > > Rama > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Command History in SQL*PLUS
Bill, I'm on NT and the up and down arrows work peachy! That's one of the few things I don't miss about Unix. I didn't think there was anything additional running on my pc to allow the arrows to work, but they do for me. Hmm... Unless you're referring to the windows client. (I just thought of this right before clicking 'send.') I use the DOS client in a cmd window just for this reason. The Windows client doesn't use the arrow keys, the DOS version does. Is that what you meant? Yosi "Thater, William" wrote: > "Deshpande, Kirti" wrote: > > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > nope, at least not with the 8.1.7 client. > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > If a program is useful, it must be changed. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Command History in SQL*PLUS
Under NT with sqlplus.exe you can use the arrow keys (that is the character version of sqlplus). I do not know how to do this with sqlplusw.exe - if anyone does it would be VERY appreciated. Regards, Bruce Reardon -Original Message- Sent: Thursday, 19 July 2001 6:26 "Deshpande, Kirti" wrote: > On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Command History in SQL*PLUS
There is a SQL command history, actually, there is more then one. SQL command history can be found in v$sql,v$sqlarea and v$sqltext. > -Original Message- > From: Thater, William [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 4:26 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Command History in SQL*PLUS > > > "Deshpande, Kirti" wrote: > > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > nope, at least not with the 8.1.7 client. > > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > If a program is useful, it must be changed. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > 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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
Re: Command History in SQL*PLUS
"Deshpande, Kirti" wrote: > On NT, I guess use your arrow keys... (Not sure of that, though).. nope, at least not with the 8.1.7 client. -- Bill "Shrek" Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
RE: Command History in SQL*PLUS
On HP-UX use 'ied' command to launch sql*plus or svrmgrl session (% ied sqlplus) . Esc-K will recall previous SQL commands (just like setting 'set -o vi' in a KSH) Check out a script #10 at http://www.orafaq.com/faqscrpt.htm#UNIX. It is wrapper for sqlplus and svrmgrl to do similar things. On NT, I guess use your arrow keys... (Not sure of that, though).. HTH, Regards. - Kirti Deshpande Verizon Information Services http://www.superpages.com > -Original Message- > From: Rama Malladi [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, July 18, 2001 2:36 PM > To: Multiple recipients of list ORACLE-L > Subject: Command History in SQL*PLUS > > Sometime ago there was a post on how to get the last commands executed > in SQL*Plus. It is very similar to doing escape from the UNIX command > line > > Do you know how to scroll down the last 10-20 commands executed in > SQL*Plus ? I am not talking about "/" which would get the last command. > > Rama > > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
