RE: SQLPlus

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Thu, 19 Feb 2004 16:39:22 -0000
Message-ID: <20F05B2143AF194CB9E300E1AEE5EF850C8A68@mhntsmail.ad.bgs.ac.uk>

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

> -----Original Message-----
> From: Sue Johnson [mailto:sue_johnson_dba_at_hotmail.com]
> Sent: Thursday, February 19, 2004 4:17 PM
> To: oracle-l_at_freelists.org
> Subject: SQLPlus
>
>
> I have the responsibility for a moderate size team which consists of
> experienced SQLPlus users as well as novice users. SQLPlus
> is causing us
> too much time loss. So we tried iSQLPlus and SQL Workbench ,
> not much
> success. Has anyone come across any tool/third party vendor
> tool that
> efficiently replaces SQLPlus? Most users are on windows pcs
> some a couple on
> linux.
>
> Sue Johnson
> DBA
> OCP
>
> _________________________________________________________________
> Take off on a romantic weekend or a family adventure to these
> great U.S.
> locations. http://special.msn.com/local/hotdestinations.armx
>
> ----------------------------------------------------------------
> 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 e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the

BGS. .                            http://www.bgs.ac.uk
*********************************************************************

----------------------------------------------------------------

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 Thu Feb 19 2004 - 10:39:22 CST