ALTER TABLE PARAMGERAL ADD (
  IDCONTROLARECCONTRATO VARCHAR2(1) DEFAULT 'N' NOT NULL, 
  CDGROPERRECCONTR VARCHAR2(2) DEFAULT NULL NULL
)
/
ALTER TABLE PARAMGERAL ADD CONSTRAINT FKGER00610GRUPOPER FOREIGN KEY (CDGROPERRECCONTR, NRORG) REFERENCES GRUPOPER (CDGRUPOPER, NRORG)
/
ALTER TABLE PARAMGERAL ADD CONSTRAINT CKC_IDCONTROLARECCONTRATO CHECK (IDCONTROLARECCONTRATO IN ('S', 'N'))