SQL*Plus with readline

From: Daniel Hanks <hanksdc_at_about-inc.com>
Date: Tue, 16 Dec 2003 14:09:32 -0800
Message-ID: <F001.005DA1C8.20031216140932@fatcity.com>

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

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daniel Hanks INET: hanksdc_at_about-inc.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 Tue Dec 16 2003 - 16:09:32 CST