CODE EXAMPLE FOR SQL

check constraint is violated

CONSTRAINT ck_ni_number
  CHECK (REGEXP_LIKE(ni_number, '[a-z][a-z][0-9][0-9][0-9][0-9][0-9][0-9][a-z]'))