| 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: TOAD v/s PL/SQL Developer
I have been using PL/SQL Developer for many years and put alot of functionality requests for some of the new features in the 3.x and 4.x product. I would be more than happy to answer any questions you have about the product.
But to answer your question. The debugger in PL/SQL developer simply rocks,
single step in PL/SQL. Toad has a few neat saved scripts that benefit DBA
but most people have similar scripts saved already or more thorough
monitoring. Until version 4.x, export/import functionality was only
available through oracle supplied tools, also the ability to output a table
data into sql statements was only available to Toad. 4.0 PL/SQL developer
has that functionality as well.
PL/SQL developer has a fully SQL Plus compliant interactive shell, and a SQL
Window which is more similar to the toad interface. PL/SQL developer has a
delphi/vb like code insight feature which rocks when looking at packages,
schemas, objects you can't remember the exact package, argument, or column
data type. Toad I don't believe has this yet. Toad is $750, PL/SQL
developer is as low as $50 when buying 20 licenses and has excellent
support. Where Quest support on toad is marginal from what I hear (this
statement I cannot back up as I never had to call them). PL/SQL developer
has a nice dual mode SQL*PLUS window, one for interactive, one for script
building which is like an instant 'ed' in sqlplus which is accessable via a
mouse click. The single button access to Explain plan and statistics is
great under PL/SQL, which toad does, but not as easy to get to. PL/SQL has
a very customable browser of objects down to recent change to name an d
schema which is really nice. Both products allow multiple sessions under
the current user which is great. Toad has the option to add a tuner which
PL/SQL developer does not have this option. (Which I think Quest Vision
Expert is more suitable for this anyway). PL/SQL developer has a handy
document menu which you can store documents commonly used (PDF's and DOCS)
to have one click access to. Toad has a few more built in dba options as
menu items to do things like rebuild indexes and such. PL/SQL Developer can
do macros where Toad cannot. PL/SQL Developer looks a little more upto date
interface and has customizable tool bar. Toad does have Proc agument
feature, but it isn't as slick as PL/SQL Developers.
Sorry about the long email, just being thorough.
"Walking on water and developing software from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Thursday, May 31, 2001 3:38 PM
To: Multiple recipients of list ORACLE-L
Folks,
Just got an e-mail from my Damager that there is a concern about the cost
of TOAD licensees and an effort is being made to find a suitable
replacement. Evaluation of PL/SQL Developer by Allround Automations is
underway. Anyone knows the pros/cons of using this (PL/SQL Developer)
product in place of TOAD. We have been TOADing since it used to be a
freeware.
All and any comments welcome..
Thanks
Regards,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: kirti.deshpande_at_verizon.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 31 2001 - 16:27:00 CDT
 |
 |