PROGRAMMING STRUCTURES IN PL/SQL:

 a) Code maintenance can be made easier by
          1) Documenting code with comments.
          2) Developing a case convention for the code
          3) Developing naming conventions for identifiers and other objects.
          4) Enhancing readability by indenting.
b) SQL statements, PL/SQL keywords and datatypes are kept in uppercase.
c) Identifiers and parameters, database tables and columns are kept in lower casing and initcap casing.
d) The names of local variables and formal parameters take precedence over the names of database tables.
e) The names of columns take precedence over the names of local variables.