RE: SQLPlus -- replacement tool
- From: "Robson, Peter" <pgro@xxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 20 Feb 2004 20:50:37 -0000
Donald - I can only endorse your praise for Ultraedit. Like yourself, I too
have been using it in just the way you desrcribe for several years. The
combination of macros and columns is invaluable.
But I never connected it to sql*plus - please, tips on how to do this!
peter
edinburgh
> -----Original Message-----
> From: Freeman, Donald [mailto:dofreeman@xxxxxxxxxxx]
> Sent: Friday, February 20, 2004 4:14 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: RE: SQLPlus -- replacement tool
>
>
> I just confirmed, and set up Ultraedit to connect to sqlplus.
> It looks =
> like I can pass either the active file as a parameter or
> whatever I have =
> highlighted into the command line. Also, I can capture the
> output to a =
> file as well. OK, so now it does just about everything the
> expensive =
> tools do for thirty bucks. Mladen - just 30 bucks - sheesh.
> That's a lot =
> less than most games cost. Oh, 'x' guys don't have games?
> Or just ones =
> where you have to type a lot <g>.
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Sue Johnson
> Sent: Friday, February 20, 2004 2:56 AM
> To: oracle-l@xxxxxxxxxxxxx
> Cc: odtug-dev-2k@xxxxxxxxxxx
> 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
>
> _________________________________________________________________
> Find and compare great deals on Broadband access at the MSN
> High-Speed=20
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
