Re: Unix tools for Oracle DBs

In article <6mojnv$dvs_at_top.mitre.org>, Marc Brooks <mwbrooks_at_olympus.mitre.org> wrote:
>Hi all,
> I'm doing some web development that uses an Oracle
>DB as the backend. I'm doing the scripting from a Linux
>box, and I was wondering if there were any utilities that
>allowed manipulation of the DB. Something like SQL*Plus for
>Linux would be great, but I'd be happy with a command-line
>program. The DB is running on a WinNT box, so telnetting
>in is not possible. I do have access to other flavors of
>Unix, so any Unix utility will probably be of use.

Try 'Wosql' (Windowing Oracle SQL) that comes with my Oratcl package. Wosql is an SQL processor for X11, includes data dictionary support, separate editing/results frames, circular command line buffers, more. Written in Tcl/Tk, and runs on Unix and Windows. Oratcl is used by Oracle for their Oracle Enterprise Manager software, this is the Open Source (TM) standalone version.

The drawback for you is that it requires Oracle's OCI library for compiling, which is not available for Linux. If you have (or can get) OCI for your other Unix boxes, you should be able to run Wosql on your other box, and direct your DISPLAY variable back to your Linux box. You might be able to get it to compile using various Linux & Oracle for SCO schemes, but I haven't tried it myself.

See my web page for details, screen samples, and download hot links.

-- 
Tom Poindexter                       Does any spammer really think that I'd
tpoindex_at_nyx.net                     buy something from them?
http://www.nyx.net/~tpoindex/