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: Christopher Spence <cspence_at_FuelSpot.com>
Date: Thu, 31 May 2001 15:48:49 -0700
Message-ID: <F001.003172C6.20010531154655@fatcity.com>

  Mark Qualter who handles support for the product is great. Very responsive to requests reguarding features as well as bugs.

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 5/31/01 6:33 PM

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Christopher Spence
  INET: cspence_at_FuelSpot.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:48:49 CDT

Original text of this message

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