Sometimes a programming background can make a task harder than it is, especially if you lose sight of what SQL can do independently of PL/SQL. Learn when it is to our best advantage to use a pure SQL approach rather than switching to PL/SQL.
This story continues at
http://www.dbasupport.com/oracle/ora10g/code.shtml
