Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: TOAD v/s PL/SQL Developer
Hi Chris,
Thank you for your detailed response. I have forwarded it to our
Developers. It would be very helpful..
Glad to know that you have contributed to the product's functionality.
Thanks.
> -----Original Message-----
> From: Christopher Spence [SMTP:cspence_at_FuelSpot.com]
> Sent: Thursday, May 31, 2001 4:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
>
>
>
>
-- 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).Received on Thu May 31 2001 - 17:04:36 CDT
![]() |
![]() |