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: SQL*Plus with readline

Re: SQL*Plus with readline

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Tue, 16 Dec 2003 15:09:29 -0800
Message-ID: <F001.005DA1CE.20031216150929@fatcity.com>


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).
Received on Tue Dec 16 2003 - 17:09:29 CST

Original text of this message

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