| 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 -- replacement tool
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
I can convert this:
10000000=20 10000000=20 10010000=20 10020000=20 10030000=20 10030010=20 10030020=20 10030030=20 10030040=20 10040000=20 10060000=20 10070000=20 10080000=20 10090000=20 10100000=20
Into this:
('10000000',
'10000000',
'10010000',
'10020000',
'10030000',
'10030010',
'10030020',
'10030030',
'10030040',
'10040000',
'10060000',
'10070000',
'10080000',
'10090000',
'10100000');
With one macro or:
PROG_AREA_DIM
OUTBREAK_DIM
PROVIDER_DIM
DATA_QUALITY_AUDIT
REASON_TYPE_CD
DATA_QUALITY_DETAIL
DISEASE_RPT_FACT
INV_STS_DIM
DIAG_DIM
Into this:
(prog_area_dim, outbreak_dim, provider_dim, data_quality_audit, = reason_type_cd, data_quality_detail, disease_rpt_fact, inv_sts_dim, = diag_dim)
Next, by using the column mode ala` Bart Simpson mode I can turn this:
AAAYkJAAFAAACJgAAA
AAAYkJAAFAAACJgAAB
AAAYkJAAFAAACJgAAC
AAAYkJAAFAAACJgAAD
AAAYkJAAFAAACJgAAE
AAAYkJAAFAAACJgAAF
AAAYkJAAFAAACJgAAG
AAAYkJAAFAAACJgAAH
AAAYkJAAFAAACJgAAI
AAAYkJAAFAAACJgAAJ
AAAYkJAAFAAACJgAAK
AAAYkJAAFAAACJgAAL
AAAYkJAAFAAACJgAAM
AAAYkJAAFAAACJgAAN
Into this:
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAA';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAB';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAC';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAD';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAE';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAF';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAG';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAH';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAI';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAJ';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAK';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAL';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAM';
UPDATE inv_fact SET processed indicator =3D'Y' WHERE rowid =
=3D'AAAYkJAAFAAACJgAAN';
By typing all the lines simultaneously. And I don't know what the upper =
limit is. You can use
sql generating sql to do this but if it's not very complicated I can do =
this in about 10 seconds.
I guarantee you'll improve your productivity by leaps and bounds. = Everybody I have ever demoed this for got one. (I do not work for this company or have any financial interest in it).
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sue Johnson
Sent: Friday, February 20, 2004 2:56 AM
To: oracle-l_at_freelists.org
Cc: odtug-dev-2k_at_fatcity.com
Subject: Re: SQLPlus -- replacement tool
OK, let me be more specific.
I have used toad,nav,PL/SQL developer for several years. (I still need =
to=20
research benthic & tora).
My team (of 40+ users) who are all using sqlplus, comprises of 25-30=20 developers, 3 dbas, and end users (some technical, some non tech).
In my opinion, sqlplus is a great tool, however the problem:
"ed" is not a great editor, hardly any help in building the sql like=20
table/column lists, "." drop down as in toad, no security other than =
PROFILE=20
table or priv/role managed synonymed user (pain to maintain), no GUI =
window=20
for changing data as in toad & probably benthic (for DML), its a no-no =
tool=20
for lower end developers and end-users, no real history, no script=20
management, ... I bang away at sqlplus, but its still too slow at tasks =
that=20
toad does in a giffy.
toad/nav: problem's that there's too much. gui drop tables, gui rebuild=20
index, gui this gui that, gui everything... gui cascade destroy your=20
database schema and data...this causes me loss of sleep, problems:
toad does not have the lovely classic sqlplus semicolon enter, if you =
run a=20
script and it errors then script execution stops unlike sqlplus (my=20
favorite) which runs scripts separated by ';' and continues even if some =
errored. Powerful. toad/nav editor is not well designed from this =
angle,=20
too mouse driven. No security or security levels.
What I am looking for is the power of SQLPLUS!, same sort of interface =
with=20
power. I was hoping isqlplus or the workbench would cut it, but lets =
face=20
it, we have ways to go. I am looking for a tool where developers/users =
are=20
forced to write commands like in sqlplus, however, at a rapid pace, much =
more efficiently, with histories, with cut-paste, with lists, with '.'s, =
with semi-colons, with easy DML windows especially for updates, with =
easy=20
spooling, spool management, spool history, with security levels for =
dbas,=20
developers and end users, .....why does not the workbench have this, =
larry?
...(Deep breath)
So, then who can suggest a tool... what should I use?
Sue Johnson
DBA
OCP
Yes, one can suggest a variety of tools (Toad, Benthic, etc etc), but =
first
need to answer the question 'what is causing you too much time loss'.
Depending on that answer - one might direct you to one of these tools, =
or
perhaps even to purpose-built SQL*scripts. It all depends on what you =
are
trying to do. For example, there is no way I allow our people to build
corporate audit triggers themselvs, either in SQL or Toad etc. They run =
a
script which I built which dynamically builds the trigger for them -
according to our standards.
I have an inbuilt distruct of gui tools, particularly when passed to the less experienced users. At least with properly written SQL stuff you can control, prompt and constrain the users.
good luck!
peter
edinburgh
-- 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 -----------------------------------------------------------------Received on Fri Feb 20 2004 - 08:00:07 CST
 |
 |