| 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
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_at_state.pa.us]
> Sent: Friday, February 20, 2004 4:14 PM
> To: oracle-l_at_freelists.org
> 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_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
>
> _________________________________________________________________
> 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_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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>
BGS. . http://www.bgs.ac.uk ********************************************************************* ----------------------------------------------------------------Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 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 - 16:03:02 CST
 |
 |