| 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
peter,
I am quite surprised that there are so few tools available. One would think
there would be many more out there??
Sue
DBA
OCP
>From : Robson, Peter <pgro_at_bgs.ac.uk>
Reply-To : oracle-l_at_freelists.org
Sent : Friday, February 20, 2004 3:53 AM
To : "'oracle-l_at_freelists.org'" <oracle-l_at_freelists.org>
Subject : RE: SQLPlus -- replacement tool
| | | Inbox
Nice one, Sue!
Yes, a pretty comprehensive review. Lots there I can identify with. Perhaps I can feed this lot into the spec for a tool I have long wanted to build. I know of nothing to match your spec. There are still pretty huge gaps in the end-user power-user domain, it seems to me.
peter
edinburgh
>-----Original Message-----
>From: Sue Johnson [mailto:sue_johnson_dba_at_hotmail.com]
>Sent: Friday, February 20, 2004 7: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
>research benthic & tora).
>
>My team (of 40+ users) who are all using sqlplus, comprises of 25-30
>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
>table/column lists, "." drop down as in toad, no security other than
>PROFILE table or priv/role managed synonymed user (pain to maintain), no
>GUI window for changing data as in toad & probably benthic (for DML), its a
>no-no tool for lower end developers and end-users, no real history, no
>script management, ... I bang away at sqlplus, but its still too slow at
>tasks that toad does in a giffy.
>
>toad/nav: problem's that there's too much. gui drop tables, gui rebuild
>index, gui this gui that, gui everything... gui cascade destroy your
>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
>script and it errors then script execution stops unlike sqlplus (my
>favorite) which runs scripts separated by ';' and continues even if some
>errored. Powerful. toad/nav editor is not well designed from this angle,
>too mouse driven. No security or security levels.
>
>What I am looking for is the power of SQLPLUS!, same sort of interface with
>power. I was hoping isqlplus or the workbench would cut it, but lets face
>it, we have ways to go. I am looking for a tool where developers/users are
>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
>spooling, spool management, spool history, with security levels for dbas,
>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
-- 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 Wed Feb 25 2004 - 02:28:31 CST
 |
 |