neilkodner.com

One of my favorite PL/SQL techniques used in batch job development is to add an extra parameter, default it to NULL, so that I can test a single account at a time. example CREATE PROCEDURE bill_employers(in_employer_id DEFAULT NULL) IS BEGIN FOR employer in SELECT emp.employer_id , emp.account_number , emp.bill_amt FROM employer emp WHERE emp.employer_id = [...]