Jan 212013
 
create procedure use_many_comments as
--*******************************************
-- Use many comments
-- Purpose:
--  Make it easier for yourself and others to
--  figure out what you were trying to 
--  accomplish.
-- Modified:
--  2013.01.02 
--  Brian Leach of Anchorage Alaska Created
-- Notes:
--  Comments are critical, especially when you
--  are doing something unusual. When the 
--  system  is down or giving an erroneous 
--  result, good  comments may mean the
--  difference between a 10 minute fix or a 10
--  hour ordeal. When it comes time for 
--  enhancements, good comments eliminate the 
--  need to trace through every detail of the 
--  code.
-- *******************************************
begin
  a_complex_series_of_logic();
end;
/
I've been through the pain of trying to understand complex code out-of-hours;
some basic comments go a long way to easing the frustration of these situations

Many thanks to Brian Leach, fellow PL/SQL Challenge player, for providing this

 Leave a Reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)