CREATE SEQUENCE  "T_CONDITION_ID_SEQ" INCREMENT BY 1 START WITH 1;

  CREATE TABLE "T_CONDITION" 
   (	"ÈÄ" NUMBER NOT NULL, 
	"ÍÀÈÌÅÍÎÂÀÍÈÅ" NVARCHAR2(128) NOT NULL, 
	"ÀÁÁÐ" NVARCHAR2(16) NOT NULL, 
	 CONSTRAINT "T_CONDITION_PK" PRIMARY KEY ("ÈÄ")
  );
  
CREATE OR REPLACE TRIGGER T_CONDITION_ID_TRIGGER
BEFORE INSERT ON T_CONDITION
FOR EACH ROW
BEGIN
  :NEW.ÈÄ := T_CONDITION_ID_SEQ.nextval;
END;
/

INSERT INTO T_CONDITION (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ) VALUES ('Ïðèíÿò','ïðíð');
INSERT INTO T_CONDITION (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ) VALUES ('Ïåðåâåäåí â äðóãîé îòäåë','ïâäî');
INSERT INTO T_CONDITION (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ) VALUES ('Ïåðåâåäåí íà äðóãóþ äîëæíîñòü','ïâää');
INSERT INTO T_CONDITION (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ) VALUES ('Óâîëåí','óâëí');