Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQLPlus -- replacement tool
Donald,
A great post! :)
"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."
Just a quick tip here - if you want to use an icon that is tied up in an exe, there is a freeware tool called Icon Shop that can grab all the icons associated with a program.. You can download it from:
http://users.pandora.be/liontech/Downloads.htm
I've attached a zipped copy of the icon from sqlplusw.exe - as I already use IconShop so that we can create CD image icons..
Trademarks and Copyrights apply etc. I suppose.
Regards
Mark
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman, Donald
Sent: 23 February 2004 14:17
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"
Example: sqlplus username/password_at_database @"%p%n%e"
The @"%p%n%e" appended to the command line will:
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). >
> 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
> =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
> 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 > ----------------------------------------------------------------->
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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 ----------------------------------------------------------------- --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 09/02/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.581 / Virus Database: 368 - Release Date: 09/02/2004 -- Binary/unsupported file stripped by Ecartis -- -- Type: application/x-zip-compressed -- File: SQLPLUSICON.zip ---------------------------------------------------------------- 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:28:28 CST
![]() |
![]() |