Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLPlus -- replacement tool

RE: SQLPlus -- replacement tool

From: Robson, Peter <pgro_at_bgs.ac.uk>
Date: Mon, 23 Feb 2004 14:39:48 -0000
Message-ID: <20F05B2143AF194CB9E300E1AEE5EF850C6A40@mhntsmail.ad.bgs.ac.uk>


Neat - thanks very much, Donald.

peter
edinburgh

> -----Original Message-----
> From: Freeman, Donald [mailto:dofreeman_at_state.pa.us]
> Sent: Monday, February 23, 2004 2:17 PM
> To: oracle-l_at_freelists.org
> Subject: RE: SQLPlus -- replacement tool
>
>
> Open up the 'Advanced' menu bar item, select 'Tool Configuration'
>
> In the command line enter:
>
> Example: C:\OraHome1\bin\sqlplusw username/password_at_database
> @"%p%n%e"
> -- Will bring up the Windows GUI.
> -- I hardcoded my password into this although you can
> use %modify% in =
> the password position. It will then pop up a box to enter your new =
> parameter. It's a little clunky.
>
> Example: sqlplus username/password_at_database @"%p%n%e"
> -- Will bring up sqlplus in a command window
>
> The @"%p%n%e" appended to the command line will:
> -- Pass the path, filename, and extension of the active
> file. Make sure =
> you preface the string with the '@' character.
>
> An invalid working directory will generate an:
> --'Error creating process 267' alert window
>
> Select 'Windows Program' and 'Output to List Box'.
> Name your tool
> Select 'Insert' to insert your new tool name into the list
> box at the =
> bottom.
> To edit your tool after you've inserted it, double click the
> name in the =
> list box and it will repopulate all the fields.
> After you edit it, select 'replace'.
>
> Under 'Advanced' you can change the default icon. I want to use the =
> Sqlplus icon but it doesn't appear to be a separate icon file. It's =
> bound up in the executable. =20
>
> To bind your new tool to a hot key -
>
> Pull down menu "Advanced" --> "Configuration.."
> "Key Mapping" tab, scroll WAY down to
> "AdvancedUserTool1" the default mapping is Ctrl+Shift+0 (zero).
>
> There doesn't appear to be any way to pass a selected sql command =
> directly into Sqlplus or capture the output directly without a spool =
> command present in the active file. At least I haven't
> figured it out =
> yet.
> I also created a CMD window tool and a Windows Explorer tool
> at the same =
> time that will pull up the directory tree of the active file.=20
>
> Anyway, if it's appropriate on this forum, if any other Oracle users =
> have good ideas about how to extend the Sqlplus/UE functionality I'd =
> like to hear about it!
>
>
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Robson, Peter
> Sent: Friday, February 20, 2004 3:51 PM
> To: 'oracle-l_at_freelists.org'
> Subject: 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 =3D
> > like I can pass either the active file as a parameter or
> > whatever I have =3D
> > highlighted into the command line. Also, I can capture the
> > output to a =3D
> > file as well. OK, so now it does just about everything the
> > expensive =3D
> > tools do for thirty bucks. Mladen - just 30 bucks - sheesh.
> > That's a lot =3D
> > less than most games cost. Oh, 'x' guys don't have games?=20
> > Or just ones =3D
> > 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 =3D
> > to=3D20
> > research benthic & tora).
> >
> > My team (of 40+ users) who are all using sqlplus, comprises
> > of 25-30=3D20
> > 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=3D20
> > table/column lists, "." drop down as in toad, no security
> other than =
> =3D
> > PROFILE=3D20
> > table or priv/role managed synonymed user (pain to
> maintain), no GUI =
> =3D
> > window=3D20
> > for changing data as in toad & probably benthic (for DML),
> > its a no-no =3D
> > tool=3D20
> > for lower end developers and end-users, no real history, no =
> script=3D20
> > management, ... I bang away at sqlplus, but its still too
> > slow at tasks =3D
> > that=3D20
> > toad does in a giffy.
> >
> > toad/nav: problem's that there's too much. gui drop tables,
> > gui rebuild=3D20
> > index, gui this gui that, gui everything... gui cascade
> > destroy your=3D20
> > database schema and data...this causes me loss of sleep, problems:
> > toad does not have the lovely classic sqlplus semicolon
> > enter, if you =3D
> > run a=3D20
> > script and it errors then script execution stops unlike sqlplus =
> (my=3D20
> > favorite) which runs scripts separated by ';' and continues
> > even if some =3D
> >
> > errored. Powerful. toad/nav editor is not well designed
> from this =
> =3D
> > angle,=3D20
> > too mouse driven. No security or security levels.
> >
> > What I am looking for is the power of SQLPLUS!, same sort of
> > interface =3D
> > with=3D20
> > power. I was hoping isqlplus or the workbench would cut it,
> > but lets =3D
> > face=3D20
> > it, we have ways to go. I am looking for a tool where
> > developers/users =3D
> > are=3D20
> > forced to write commands like in sqlplus, however, at a rapid
> > pace, much =3D
> >
> > more efficiently, with histories, with cut-paste, with lists,
> > with '.'s, =3D
> >
> > with semi-colons, with easy DML windows especially for
> updates, with =
> =3D
> > easy=3D20
> > spooling, spool management, spool history, with security
> levels for =
> =3D
> > dbas,=3D20
> > developers and end users, .....why does not the workbench
> have this, =
> =3D
> > 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 =3D
> > 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, =3D
> > or
> > perhaps even to purpose-built SQL*scripts. It all depends on
> > what you =3D
> > 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 =3D
> > 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=3D20
> > 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
> > -----------------------------------------------------------------
> >
>
>
> *********************************************************************
> 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
> -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
-----------------------------------------------------------------
Received on Mon Feb 23 2004 - 08:52:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US