Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: TOAD v/s PL/SQL Developer

RE: TOAD v/s PL/SQL Developer

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Thu, 31 May 2001 15:04:36 -0700
Message-ID: <F001.0031713F.20010531143310@fatcity.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US