Another constraint question...

[jmodic]

ALTER TABLE my_table ADD CONSTRAINT check_acct_bal
CHECK (acct_type = '1' AND act_bal > 0
       OR
       acct_type = '2' AND act_bal > 100
       OR
       etc....
      );