Has anyone tried gqlplus? I think this is an open source alternative, but it may not be entirely an alternative, as I think it uses sqlplus.
-----Original Message-----
From: Cary Millsap [mailto:cary.millsap_at_hotsos.com]
Sent: Fri 2/20/2004 10:02 AM
To: oracle-l_at_freelists.org
Cc:
Subject: RE: SQLPlus -- replacement tool
I'm interested in this conversation because scripting in sqlplus is so
horrific. The SQL optimization harness we've written to sit atop sqlplus
is 10x more lines of code that we want it to be, and it still fails to
offer basic features that we'd expect from a real scripting language.
For example, you I don't think you can test whether a variable (e.g., a
command line arg) has been set without prompting for its value if its
value is undefined. Stuff like that...
So, to twist the conversation slightly, is there a more decent
sqlplus-like scripting tool out there? What I'd love to find is a
sqlplus-alike that lets me use Perl or Korn shell syntax instead of just
SQL and the meager set of sqlplus set commands...
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 Seattle
- SQL Optimization 101: 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mladen Gogala
Sent: Friday, February 20, 2004 8:17 AM
To: oracle-l_at_freelists.org
Subject: Re: SQLPlus -- replacement tool
I use "vim". It has "set syntax=oracle" command, or, my favorite, "set
syntax=perl",
and it isn't as expensive as UltraEdit32. I have yet to find an editor
capable of
supporting regular expressions as well as "vi". And you know what: it's
everywhere
where I go. There is a "vi" version for everything, with the possible
exception of
IBM mainframe. IBM mainframes have been appropriately named: the latest
and the greatest
is called "T-Rex" (not a joke, it's true). Asteroid is traveling fast
and Jurassic is
coming to an end.
On 02/20/2004 09:00:07 AM, "Freeman, Donald" wrote:
> I use UltraEdit32. Its a programming text editor with about 1000
built =
> in functions. I think a single license copy is $35. It supports sql
and =
> pl/sql syntax highlighting, column editing (which I used extensively
to =
> create a million sql statements at a time), very large file support, =
> built in ftp client, regular expressions, most unix like functions,
like =
> grep, sort, uniq, multiple clipboards, templates, macros. You can edit
=
> in hex, ascii, ebcdic, unix, mac. It has won several awards. I have =
> been using it in combination with sqlplus for five years. I have both
=
> TOAD and DBArtisan but prefer Ultraedit. It's possible that it can be
=
> linked directly to sqlplus. I know you can run programs from it but =
> haven't tried to link it. You can make it your default editor. It has
=
> improved my sql productivity 100%. =20
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
-- Binary/unsupported file stripped by Ecartis --
-- Type: application/ms-tnef
-- File: winmail.dat
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 20 2004 - 09:48:36 CST
