imposing check constraint on table

[LKBrwn_DBA]

Maybe try a before insert/update trigger:

-- etc --
  If INSERTING Or UPDATING('BORE') 
  Then
    If :new.bore > 14 and :new.numguns => 9 Then RAISE; End If;
  End If;
-- etc --