Can multiple multiple conditions be given within check constraint
966083Oct 10 2012 — edited Oct 11 2012Hi,
I have am agent table where city and commission is there. While inserting records, I need to enforce a rule that if city is London then commission cannot be less than 300. Can it be done using check constraints? I have been able to do it using PL/SQL. Just want to know if it could be done using check constraints. If yes, then need the syntax please.