From oracle-l-bounce@freelists.org Mon Feb 23 08:52:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1NEq9c23891 for ; Mon, 23 Feb 2004 08:52:09 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1NEq8o23884 for ; Mon, 23 Feb 2004 08:52:08 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CEE1C394AA0; Mon, 23 Feb 2004 09:53:45 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 23 Feb 2004 09:52:38 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mhp010.nerc-murchison.ac.uk (mhp010.nerc-murchison.ac.uk [192.171.157.135]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4EC32394E30 for ; Mon, 23 Feb 2004 09:52:35 -0500 (EST) Received: from mhnts2.nerc-murchison.ac.uk (mhnts2.nerc-murchison.ac.uk) by mhp010.nerc-murchison.ac.uk (Content Technologies SMTPRS 4.3.10) with ESMTP id for ; Mon, 23 Feb 2004 14:43:52 +0000 Received: by mhnts2.nerc-murchison.ac.uk with Internet Mail Service (5.5.2656.59) id ; Mon, 23 Feb 2004 14:39:49 -0000 Message-ID: <20F05B2143AF194CB9E300E1AEE5EF850C6A40@mhntsmail.ad.bgs.ac.uk> From: "Robson, Peter" To: "'oracle-l@freelists.org'" Subject: RE: SQLPlus -- replacement tool Date: Mon, 23 Feb 2004 14:39:48 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-archive-position: 1578 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: pgro@bgs.ac.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l Neat - thanks very much, Donald. peter edinburgh > -----Original Message----- > From: Freeman, Donald [mailto:dofreeman@state.pa.us] > Sent: Monday, February 23, 2004 2:17 PM > To: oracle-l@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@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@freelists.org > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Robson, Peter > Sent: Friday, February 20, 2004 3:51 PM > To: 'oracle-l@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@state.pa.us] > > Sent: Friday, February 20, 2004 4:14 PM > > To: oracle-l@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 . > > > > -----Original Message----- > > From: oracle-l-bounce@freelists.org > > [mailto:oracle-l-bounce@freelists.org]On Behalf Of Sue Johnson > > Sent: Friday, February 20, 2004 2:56 AM > > To: oracle-l@freelists.org > > Cc: odtug-dev-2k@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@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@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@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@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@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 -----------------------------------------------------------------