Oracle Database Discussions

I wanted to implement a list of coding standards and code quality checks for my oracle packages,functions,views,tableetc .

for example

All variables with number datatype should start with N_ and charcter type with C_ in all my tables & views definition.

This can be identified during peer review & can be corrected, but i think this is a repeated process which i don want to burden the developers rather i wanted a tool which does all these kind of checks which can be automated.

Is there any tool which does this operation or can someone give me a little idea how can i automate these stuffs bu creating a generic oracle procedure which can run through all the tables,views and generate a error report for those which are deviating from the standards.

Thus we can reduce the manual effort spent on peer review, please suggest.

thanks in advance