Debug sql/pl statement

Posted on 2011-05-07
Last Modified: 2013-12-12
I like to know which a good software for debugging oracle sq/pl statement?
Question by:abdulla110884
    LVL 3

    Accepted Solution

    LVL 3

    Expert Comment

    There is also a plugin for eclipse I think, but you'll probably use it if you already use eclipse for java/php/other development...
    LVL 23

    Assisted Solution

    - we use PL/SQL Developer. i'm not sure of other product but i like the Step In, Step Over, Step Out debugger as what i used to when using vb.
    LVL 1

    Assisted Solution

    The best one is dbms_profiler free and is a oracle tool.

    Find in metalink how to use. If you cant I can make an article of it.

    Assisted Solution

    I would say PLSQL Developer and Toad.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Article by: Swadhin
    From the Oracle SQL Reference ( we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
    Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now