May 29, 2018 5:39:08 PM by Clarisa Maman Orfali
In this article, we will learn to analyze code using the Toad Code Analysis diagnostic tool.
This tool shows a series of industry standard metrics that are very useful to determine the following:
For example, this tool can be used by a project manager to assign developers for a new project. These reports can quickly assess the type of code and help the project manager decide who, in terms of skill level, would be required for the project.
On the other hand, developers can use this analysis tool to establish, for example, a reference status of the code they are about to work on and then compare it with the same elements of the report once the programming task has been completed.
This information provided by this tool can be used to help developers make sure they don’t make any mistakes. This feature can also be used to evaluate software packages based on the Oracle code and compare the code between the solutions being considered.
This feature is available in the Toad for Oracle Professional Edition and higher.
We select from the Database menu > Diagnose > Code Analysis:
We can analyze packages, functions, and procedures. For example, for this demo we will work on the analysis of a package called MINUEVOPAQUETE.
To load all the packages that we have available in our schema, we select the "Load Objects" icon.
Then we select “Load My Packages”.
We select the package that we want to analyze. We can see two panels open: On the left side, we see the “Results tab” of the selected package, in which the analysis results will appear after we run the tool. On the right side, we can see the package code. In this example we are going to analyze a simple package as a demonstration.
In the “Report tab”, which is located next to the “Results tab”, we can see a Table of Contents.
This table of contents shows us the definitions of the metrics used by this analysis tool. Each of the metrics is explained in the table of contents in terms of how they are used by the tool.
- n1 = the number of distinct operators
- n2 = the number of distinct operands
- N1 = the total number of operators
- N2 = the total number of operands
Knowing these metrics, we are able to perform the analysis of our package.
We go to the “Results tab”, having selected the package we want to analyze.
We click on the green triangle button "Analyze code for all selected items"; or, we can press the F9 key.
When executing the analysis of the package we can visualize the metrics in the Results tab:
- Halstead Volume: 27 (code easy to maintain and understand)
- McCabe’s Cyclomatic: 2 (It’s a very simple program)
- Maintainability Index: 122.17 (Easy to maintain code)
- Toad Code Rating (TCR): 1 (a simple classification by Toad that has 4 possible values: from 1 to 4, with 1 being the best and 4 being the worst)
At first glance, with this analysis we can determine that this code is easy to maintain and easy to understand by the developer. Then, the project manager can select which developer is appropriate to maintain the code.
We will quickly analyze another complex code, in this case the package is called EBA_PROJ_STATUS_API.
We can observe the values of the following metrics:
- Halstead Volume: 1,667 (code is a bit more complex, more challenging and it would take a bit more of the developer's skills to be able to change the content of the code)
- McCabe’s Cyclomatic: 26 (it's a complex program)
- Maintainability Index: 59.08 (the code is difficult to maintain)
- Toad Code Rating (TCR): 3 (Toad gives us a simple classification)
In addition to the code metrics we have a lot of information in the results tab, such as the Summary, Rule Violations, and Properties, which shows information about cursors, declarations, DML analysis, function analysis, procedures, etc.
An interesting section of the summary is the Module Analysis, which shows us at a glance the number of comment lines, the number of executable lines, the total number of lines, the number of declarations, the number of DML type declarations, etc.
Finally, we can see in the grid all the most important metrics of the packages we have just analyzed, highlighted by colors, which allows us to quickly see if the code is easy or not to maintain by the developer.
I invite you to use this great tool that Toad for Oracle provides us to analyze our code and know more about how we develop our program modules.
Try Toad for Oracle now
Try Toad for Oracle free for 30 days.
Already in a trial? Talk to sales or buy now online.
Already a loyal fan of Toad for Oracle? Renew now.
Webcast: How a Code Review Tool Can Help You Write Team-friendly PL/SQL [Webcast]
Video: Advanced code review using Code Analysis
Video: 'Dan's Dozen' Quick Toad Tips - Tip #9 - Code Review
Blog: Why PL/SQL Code Quality Matters
Blog: Toad Code Analysis
Blog: Toad code review - useful to the programmer
Blog: 5 fitness tips for PL/SQL code
Blog: SQL tools – 8 ways you can’t live (or work) without them
Head over to the Toad for Oracle forum on Toad World®! Chat with Toad developers, and lots of experienced users.
If you think your colleagues would benefit from this blog, share it now on social media with the buttons located at the top of this blog post. Thanks!
Tags: Toad for Oracle
Written by Clarisa Maman Orfali
Clarisa is a System Engineer with more than 24 years of experience as a developer, teacher, and consultant in Information Technology. She was a Founder and CEO between 2013 to 2020 at ClarTech Solutions, Inc., a consulting firm specializing in Oracle APEX and Open Source technologies. Clarisa entered the world of Oracle technologies in 2009. After a few years, she discovered the power of application development with Oracle Application Express (APEX) and specialized in that area.
Clarisa is from Argentina, and she is living and working in Irvine, California, in the United States. She's also a Co-Founder of the Argentina Oracle User Group (AROUG). In addition, she had actively participated in large and popular events such as the OTN Tour Argentina and Oracle APEX Tour Latin America after called Oracle Developer Tour. She's also authored the first three Spanish books about Oracle Application Express and recorded and published several Online Video Courses.
She has a great passion for Oracle technologies and wants to expand that passion and influence, transferring her knowledge and experience to the entire Latin American and worldwide Oracle communities. You can always contact her through her Twitter account (@Clari707).
Clarisa loves spending time with her family by enjoying outdoor activities with her two adored children, Melanie and Nicolas, as well as hanging out with her friends. Also, she loves traveling with her husband Julio worldwide and to takes new challenges at every moment of her life.