Why you should care
The END keyword is useful as it terminates a PL/SQL block. This keyword is found at the end of procedures, functions, packages, triggers, blocks or any type of body where an executable action is performed. In other words, it signifies the end of execution of a block.Business Impacts
Having the END keyword labelled is useful as it saves financial costs and allow the code to more agile and allows the program to be read easier as well.[nz_btn text="Cost" target="_self" animate="false" animation_type="ghost" color="green" size="small" shape="rounded" type="normal" hover_normal="opacity" hover_ghost="fill" link="http://casthighlight.wpengine.com/category/product/indicators-methodology/cost/" icon="icon-office"]CAST Recommendations
References
http://psoug.org/definition/END.htm[nz_btn text="Style Guide" target="_self" animate="false" animation_type="ghost" color="turquoise" size="small" shape="rounded" type="ghost" hover_normal="fill" hover_ghost="screen" link="https://github.com/Kristories/awesome-guidelines" icon="icon-book"]How we detect
This code insight shows that labeling the END keyword is useful to associate it with their peer instructions.About CAST and Highlight’s Code Insights
Over the last 25 years, CAST has leveraged unique knowledge on software quality measurement by analyzing thousands of applications and billions of lines of code. Based on this experience and community standards on programming best practices, Highlight implements hundreds of code insights across 15+ technologies to calculate health factors of a software.
For reference only. For the complete details please refer the original article
https://doc.casthighlight.com/alt_withoutlabel_end-avoid-missing-label-for-end-keyword/
https://doc.casthighlight.com/alt_withoutlabel_end-avoid-missing-label-for-end-keyword/
Comments