Code standards / compliance

[James]

Are there any plans to integrate Code compliance checks into PLSQL developer / Add-ons?

The Beautifier already suggests variables that are redundant;
it would be nice to highlight any variables / program units that do not meet the naming standards of the company.... and make recommendations

eg prefix rules
Exceptions = x_%
Constants = k_%
Parameter Variables = i_%,o_%,io_%
Local Variables = v_%
Global Variables = g_%
Procedures = get%,set%
etc...

 

[Marco Kalter]

We do indeed have plans for this (it's on the list of enhancement requests). It is in fact a natural extension of the hint system, though it requires additional configuration by the user. It's not implemented in 6.0, but we'll probably add it in 6.1.

 

[D Patel]

It would be good if we have capability to define those rules for code compliance check as everybody has their own coding style/standards.
When we are talking about PL/SQL beautifier Plug-ins, it doesn't beautify the way we expect. I can send you the options we have configured and output of the beutified file.