Toad World® Forums

PL/SQL code Analyze?


#1

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.


#2

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/products/toad-for-oracle/b/weblog/archive/2013/07/19/toad-for-higher-quality-pl-sql.aspx

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

To: oracle@toadworld.com

Subject: [Toad World - Oracle Discussion Forum] PL/SQL code Analyze?

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.


#3

Thanx

Is there any other 3rd party Tool?? pls let me know…


#4

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]


#5

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]


#6

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.