| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQLPlus -- restatement of the problem
Sue,
If you are looking for a tool that matches/mimics
SQLPlus exactly from UI perspective, and with the
input,execution,output,security,logging,help
lists,easy DML/DDL,etc, all in one, you should try
Active+ for windows which is currently free. If you
are looking for a free ride, here it is.
We recently obained a free copy from:
http://www.iraje.com/promos/pap/aplite.exe
There is a feature list at:
http://www.iraje.com/docs/apfeatures.htm
HTH,
Kevin
From: "Sue Johnson" <sue_johnson_dba_at_hotmail.com>
To: oracle-l_at_freelists.org
CC: odtug-dev2k-l_at_fatcity.com
Subject: Re: SQLPlus -- restatement of the problem
Date: Wed, 25 Feb 2004 00:46:34 -0800
Let me restate the problem so that we may compare apples with apples...
When using SQLPlus (or other tools) there are 3 parts:
INPUT EXECUTIONOUTPUT Now,
INPUT is horrid using notepad. So, we substitute with
UltraEdit32 (i
downloaded it, its very good), emacs, vi, bbedit(mac),
which is good,
but:
a. we are back to the toggle mode between sqlplus and
the editor
b. where is the security?
c. what about the output so that we may work with the
data, change the
data,
etc, etc....SPOOL?
So, the suggestions reg. ultraedit32, emacs, vi,
bbedit, et al, is a
quickfix for the input. Its not a comprehensive
solution for either
the
end-user or the power user.
EXECUTION in sqlplus is by far great (the greatest).
OUTPUT in sqlplus is horrid, spool file spool
on/out... terrible, so we
csv
to excel, etc. These are all work arounds, again not
a comprehensive
solution.
A comprehensive solution would involve
INPUT+EXECUTION+OUTPUT, not just
any
one aspect of this. I have downloaded most of the
windows based tools
that
were mentioned and am evaluating again, however, not
many options
here...and
that surprises me.
Sue
DBA
OCP
>From : Mladen Gogala <mladen_at_wangtrading.com>
Reply-To : oracle-l_at_freelists.org
Sent : Friday, February 20, 2004 6:16 AM
To : oracle-l_at_freelists.org
Subject : Re: SQLPlus -- replacement tool
| | | Inbox
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
-- 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 27 2004 - 00:56:00 CST
 |
 |