Neat - thanks very much, Donald. peter edinburgh > -----Original Message----- > From: Freeman, Donald [mailto:dofreeman@xxxxxxxxxxx] > Sent: Monday, February 23, 2004 2:17 PM > To: oracle-l@xxxxxxxxxxxxx > 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@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@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@xxxxxxxxxxxxx > [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Robson, Peter > Sent: Friday, February 20, 2004 3:51 PM > To: 'oracle-l@xxxxxxxxxxxxx' > 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@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 =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@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 =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@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 > ----------------------------------------------------------------- > ---------------------------------------------------------------- > 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 -----------------------------------------------------------------