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

  CREATE TABLE "T_DEPARTMENT_INFO" 
   (	"ÈÄ" NUMBER NOT NULL, 
	"ÍÀÈÌÅÍÎÂÀÍÈÅ" NVARCHAR2(128) NOT NULL, 
	"ÀÁÁÐ_ÎÒÄ" NVARCHAR2(16) NOT NULL, 
	"ÍÎÌÅÐ_ÎÒÄ" NUMBER(4) NOT NULL,
	 CONSTRAINT "T_DEPARTMENT_INFO_PK" PRIMARY KEY ("ÈÄ")
  );
  
CREATE OR REPLACE TRIGGER T_DEPARTMENT_INFO_ID_TRIGGER
BEFORE INSERT ON T_DEPARTMENT_INFO
FOR EACH ROW
BEGIN
  :NEW.ÈÄ := T_DEPARTMENT_INFO_ID_SEQ.nextval;
END;
/

INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Äèðåêòîðà','äðêò', 201);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Ìàñòåðû','ìñòð', 202);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Âîäèòåëè','âäòë', 203);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Îõðàííèêè','îõðíê', 204);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Ìàðêåòèíã','ìðêòã', 205);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Òåñòèðîâàíèå','òñò', 206);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Øòóêàòóðû-ìîëÿðû','øòìëð', 207);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Ïîääåðæêà','ïäð', 208);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Ðàçðàáîò÷èêè','ðçðá', 209);
INSERT INTO T_DEPARTMENT_INFO (ÍÀÈÌÅÍÎÂÀÍÈÅ,ÀÁÁÐ_ÎÒÄ,ÍÎÌÅÐ_ÎÒÄ) VALUES ('Óâîëüíåíèå','óâëí', 777);