Oracle 8i and 9i PL/SQL Collections and Records


	You need to see this briefly so that you can more readily read the code examples, as opposed to scratching your head wondering what on earth I’m trying to do.

	Seeing this pseudo-Hungarian notation makes most professionals who’ve seen it very glad they don’t work on my team. We’ve found it very helpful to always know exactly what we’re dealing with, rather than having to backtrack and hunt down the original variable declaration to see if it’s a string, or a number or collection. Good variable naming can bypass the need for a strict convention like this, but good variable naming often requires more characters than PL/SQL allows. So we think it’s nice for consistency, brevity, and it allows us to be a little lazy with the naming.

	It’s certainly a far site better than the sorry “p” for parameter “v” for variable convention (started by unschooled Oracle corporation programmers). What does that buy you? Almost nothing . In my mind, it’s worse than no standard at all.