ALTER TABLE PARAMORCAOPERAC ADD IDPERIODOORCA VARCHAR2(30) DEFAULT 'ANUAL' NOT NULL
/
ALTER TABLE PARAMORCAOPERAC ADD CONSTRAINT CKC_IDPERIODOORCA_PARAMORCAOPE CHECK (IDPERIODOORCA IN ('MENSAL', 'BIMESTRAL', 'TRIMESTRAL', 'QUADRIMESTRAL', 'SEMESTRAL', 'ANUAL'))
/
ALTER TABLE PARAMORCAOPERAC ADD NRDIAINIORCA NUMBER DEFAULT 1 NOT NULL
/
ALTER TABLE PARAMORCAOPERAC ADD NRDIAANTELABORCA NUMBER NULL