Hi,
Dear All is there any tool or Software for analyze PL/SQL scripts and Oracle Forms PL/SQL .
I’m new learner please help me.
Toad for Oracle has utility/screen called Code Analysis – which offers essentially “code review” and calculates common software engineering metrics to judge/improve
code:
http://www.toadworld.com/platforms/oracle/w/wiki/404.engineering-better-plsql.aspx
From: Muhammad Faraz [mailto:bounce-Muhammad_Faraz@toadworld.com]
Sent: Tuesday, August 20, 2013 4:53 AM
Subject: [Toad World - Oracle Discussion Forum] PL/SQL code Analyze?
Thread created by Muhammad Faraz
Hi,
Dear All is there any tool or Software for analyze PL/SQL scripts and Oracle Forms PL/SQL .
I’m new learner please help me.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Oracle notifications altogether.
Toad World - Oracle Discussion Forum
Flag
this post as spam/abuse.
Thanx
Is there any other 3rd party Tool?? pls let me know…
On 20/08/13 12:47, Muhammad Faraz wrote:
Is there any other 3rd party Tool?? pls let me know...
What exactly do you want to analyse in your PL/SQL? Is it something to report of "correctness" or to report on how it can be improved etc?
If yo can supply more information about what it is you want (need) then we might be able to help you a little better.
Bert, for example, has pointed to at a utility that will analyse your code - which is what you asked for originally - however, it seems that this is not what you are looking for, so we really need to know more about what you desire.
Thanks.
-- Cheers,
Norm. [TeamT]
The following search - https://encrypted.google.com/search?q=pl%2Fsql+analyser - turned up a few tools that might be of use. A couple of links from the results page are:
http://www.cocolab.com/app_plsql.html
http://www.sqldetective.com/
http://www.oracle-base.com/articles/11g/sql-performance-analyzer-11gr1.php
http://www.download32.com/pl-sql-analyser-software.html
HTH
– Cheers,
Norm. [TeamT]
SQL Optimizer for Oracle (part of Toad Xpert Edition) has a feature called Scan SQL which can analyze SQL inside embedded PL/SQL code such as Forms Triggers to identify any which may have performance issues. SQL Optimizer can then tune the SQL to improved the performance of the Oracle Form.