Prove sections of code
with test cases
uMake sure you understand how new features work
ØWrite a separate, small, example program to demonstrate functionality.
uWhen using complex expressions, isolate the piece of code in a simple SQL expression to prove that the code is correct.
ØThis can save you hours of debugging time later.
uSet up small test cases using DBMS_OUTPUT statements to print out interim results.
ØDo this frequently for each section of code written.