I don't think the pl/sql reference manual outlines any standards.
In the past, Steven Feuerstein has been doing much in this respect.
His standards are laid out in his books and -probably- on
http://www.revealnet.com
(which is right now dead slow)
and in the Knowledge Expert Code Review Module in Toad.
One obvious standard of course (due to scoping issues in PL/SQL) is to
make sure your variable names are always different from column names.
You also best prefix formal parameter definitions with p_ , like
p_empid IN number.
--
Sybrand Bakker
Senior Oracle DBA
Received on Tue Jan 31 2006 - 03:15:06 CST
