| 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
SQL Nav isn't bad, as long as the users don't rely on the cool little green
button to do any of their coding for them.
We would get scripts to move into production that wouldn't run UNLESS they were run through SQL Navigator, because it puts in the create or replace <whatever> for them, and if you are scripting a move up script to run command line, it pukes. It is actually a very good tool, as long as you only look on it as a tool and not a complete solution to all of your problems that takes the necessity of having a basic understanding away from the programmer.
We have some programmers here that I would let use just about anything they wanted. I know they have a clue and can be trusted (some of them even challenge me and keep me on my toes), but you always run the risk of one person who wants to rely a little too much on the tool.
April
April Wells
Oracle DBA/Oracle Apps DBA
Corporate Systems
Amarillo Texas
@>-->-->--
"Few people really enjoy the simple pleasure of flying a kite"
Adam Wells age 11
"Imagination is the highest kite one can fly."
Lauren Bacall
-----Original Message-----
From: Koivu, Lisa [mailto:Lisa.Koivu_at_Cendant-TRG.com]
Sent: Thursday, February 19, 2004 10:24 AM
To: oracle-l_at_freelists.org; sue_johnson_dba_at_hotmail.com
Subject: RE: SQLPlus
Hi Sue,=20
There are lots of them.=20
TOAD
SQL*Navigator
Benthic Golden
Just to name a few. There's also Oracle's SQL*Worksheet.=20
However, the users' needs must be considered. =20
IF they need a friendly db-browser and sql window, use Toad. =20
If they need pl/sql debugging, use SQL*Nav (I prefer sql*nav for this over Toad.) =20
If they just need nice command history and a bit of enhanced functionality, check out Benthic Golden. OF course, if buying licenses (Benthic is cheap) is not an option, SQL*Worksheet may fit the bill.=20
Two cents from a monkey!
Lisa Koivu
Orlando, FL, USA
-----Original Message-----
From: Sue Johnson [mailto:sue_johnson_dba_at_hotmail.com]=20
Sent: Thursday, February 19, 2004 11:17 AM
To: oracle-l_at_freelists.org
Subject: SQLPlus=20
I have the responsibility for a moderate size team which consists of=20
experienced SQLPlus users as well as novice users. SQLPlus is causing
us=20
too much time loss. So we tried iSQLPlus and SQL Workbench , not much=20
success. Has anyone come across any tool/third party vendor tool that=20
efficiently replaces SQLPlus? Most users are on windows pcs some a
couple on=20
linux.
Sue Johnson
DBA
OCP
locations. http://special.msn.com/local/hotdestinations.armx
"The sender believes that this E-Mail and any attachments were free of = any virus, worm, Trojan horse, and/or malicious code when sent. This = message and its attachments could have been infected during = transmission. By reading the message and opening any attachments, the = recipient accepts full responsibility for taking proactive and remedial = action about viruses and other defects. The sender's business entity is = not liable for any loss or damage arising in any way from this message = or its attachments."
The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies.
Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment.
 |
 |