If you want a free solution, try Emacs (I use GNU on W2k). SQLi mode runs
as a front end to sqlplus, giving you everything that sqlplus does plus
command line editing, history and cut and paste. You can also 'pop' sql
statements or whole scripts directly from another window and run them (a bit
like worksheet). There's also quite nice sql and plsql modes which give you
syntax highlighting (which is a lot faster than vim by the way) and
customised indenting. Plus of course you've got all the other goodies that
emacs gives you - I particularly like remote directory browsing via ftp.
On the downside, it doesn't have any more security than sqlplus, it takes a
fair bit of setup and it can be (very) quirky.
--
David Lord
> -----Original Message-----
> From: Sue Johnson [mailto:sue_johnson_dba_at_hotmail.com]
> Sent: 20 February 2004 07:56
> 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
>
>
>
> 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
>
> _________________________________________________________________
> Find and compare great deals on Broadband access at the MSN
> High-Speed
> Marketplace. http://click.atdmt.com/AVE/go/onm00200360ave/direct/01/
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
> This email and its attachments are confidential under
> applicable law and are intended for use of the sender's
> addressee only, unless the sender expressly agrees otherwise,
> or unless a separate written agreement exists between Iron
> Mountain and a recipient company governing communications
> between the parties and any data that may be so transmitted.
> Transmission of email over the Internet is not a secure
> communications medium. If you are requesting or have
> requested the transmittal of personal data, as defined in
> applicable privacy laws, by means of email or in an
> attachment to email, you may wish to select a more secure
> alternate means of transmittal that better supports your
> obligations to protect such personal data.
>
> If the recipient of this message is not the recipient named
> above, and/or you have received this email in error, you must
> take no action based on the information in this email. You
> are hereby notified that any dissemination, misuse or copying
> or disclosure of this communication by a recipient who has
> received this message in error is strictly prohibited. If
> this message is received in error, please return this email
> to the sender and immediately highlight any error in
> transmittal. Thank you.
>
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
This e-mail and its attachments are intended for the
author's addressee only and may be confidential.
If they have come to you in error you must take no
action based on them, nor must you copy or show
them to anyone; please reply to this e-mail and
highlight the error.
Please note that this e-mail has been created in the
knowledge that Internet e-mail is not a 100% secure
communications medium. We advise that you
understand and observe this lack of security when
e-mailing us. Steps have been taken to ensure this
e-mail and attachments are free from any virus, but
advise the recipient to ensure they are actually virus
free.
The views, opinions and judgments expressed in this
message are solely those of the author. The message
contents have not been reviewed or approved by Iron
Mountain.
*** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** *** ***
----------------------------------------------------------------
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 - 02:23:50 CST
