PL/SQL Development tools
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: PL/SQL Development tools

  1. #1
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    PL/SQL Development tools

    I would like to find a PL/SQL development tool that will help my developers analyze their code. For example, if they create a package called "DO_IT" with method "NOW", I want them to be able to do some initial analysis on DO_IT.NOW without DBA intervention. I would like a GUI tool that has some intelligence built in that will tell them if a query is poor (explain plan), runs a tkprof type trace, and has a pl/sql step debugger. Ideally, I'd like this tool to run on Solaris, but can run on Windoz if necessary.

    Any ideas?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  2. #2
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Check out www.globecom.se/tora

    TOra - Toolkit for Oracle

    I use the RH Linux version and am very impressed. It has a ton of features that'll just blow you away. Their alpha/beta versions seem to be very stable on release. No problems there.

    Here's a user's quote from their page:

    It's AWESOME! I'm a developer for a company who uses oracle a lot, but being Solaris based, haven't really had any nice tools to use. TOra, even in this pre1.0 form is sooooo cool. At last I can stop using sqlplus! I've already got about 10 people using it, and more are sure to follow...once I tell them about it.
    Richard Sheldon
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    tora == toad

    for pl/sql you could try embarcadero sql profiler or sql tuner, pl/sql developer, toad's debugger is pretty good as well

  4. #4
    Join Date
    Apr 2002
    Location
    Germany.Laudenbach
    Posts
    448

    Exclamation

    Hi,
    Take PL/SQL-Developer http://www.allroundautomations.com/
    You can get five licences for the price of one TOAD.

    And you get my absolutly favourite PL/SQL-Tool

    Orca

  5. #5

    Its TOAD for me...

    Im up for TOAD from quest. Next is Procedure Builder that comes with Oracle Developer- a sod to use but allows step-by-step running through code on the server with break-points etc.

  6. #6
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Quote Originally Posted by Orca777
    Hi,
    Take PL/SQL-Developer http://www.allroundautomations.com/
    You can get five licences for the price of one TOAD.

    And you get my absolutly favourite PL/SQL-Tool

    Orca
    This stuff rocks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width