Hi all! I am interested in this topic too(except performance questions, because i monitor it on production and on performance stress testing). Sometimes it is very hard to read pl/sql code written by different teams (or, even worse, by sql generators like hibernate). Do anybody have same conventions for PL/SQL and SQL or db objects naming conventions? Or maybe set of restrictions/best practices for developers like 'do not do ...'? Could anybody share own code conventions/standards for oracle db? For example as java developer in past, i know sun's(oracle) code convention for java - http://www.oracle.com/technetwork/java/codeconv-138413.html In addition to parsing code in commit-hooks, we can do automatic check some code rules through pl/scope, and naming rules through data dictionary . Best regards, Sayan Malakshinov Performance tuning engineer http://orasql.org -- //www.freelists.org/webpage/oracle-l