Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Plus with readline
On HPUX the ied utility enables command history. Everything you type will be logged to the HISTORY file unless you specify one.
-- Denny Koovakattu Quoting Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>:Received on Tue Dec 16 2003 - 17:54:25 CST
> At 14:09 16-12-03 -0800, you wrote:
> >I know there's a lot of folks who grumble about the spartan-ness of
> >SQL*Plus, but the only real feature I wish it had was GNU readline
> >capability for command history and editing. I've looked at some wrappers
> >(yasql, gasql), as well as replacements (henplus, which is quite nice,
> >actually), but today I found something that seems to do exactly what I
> >really want--SQL*Plus behavior, augmented with readline support (So I can
> >still do stuff like output formatting, spooling, etc., etc.,). Yes, I
> >actually dig SQL*Plus, just wish it had readline.
> >
> >So today I found a little utility called uniread:
> >
> >http://sourceforge.net/projects/uniread/
> >
> >It's a Perl program that
> >
> >"adds full readline support (command editing, history, etc.) to any
> >existing interactive command-line program. Common examples are Oracle's
> >sqlplus or jython. uniread will work on any POSIX platform with Perl."
> >
> >I tried it out with SQL*plus, and so far seems to work beautifully. Just
> >thought I'd share.
> >
> >-- Dan
> >========================================================================
> > Daniel Hanks - Systems/Database Administrator
> > About Inc., Web Services Division
> >========================================================================
>
> Don't know this particular one, but ran into a shell on HP-UX with similar
> capabilities. I was a developer those days, and the feature I liked most
> was its capability to unveil sys/system passwords. Just get this shell
> running and ask the DBA to do something from your terminal. After that, the
>
> non-echoed password will be perfectly visible in command-line history
> (after the DBA left the scene, of course). They never found out how we were
>
> able to discover their passwords. I think it's now safe to spread the
> knowledge around.
>
> Does this tool have the same 'functionality'? So, be carefull, or take
> advantage of it ;-).
>
>
> Regards, Carel-Jan
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Carel-Jan Engel
> INET: cjpengel.dbalert_at_xs4all.nl
>
> 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).
>
---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu INET: groups_at_koovakattu.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).