insert into COMPUTER values(46,'AMD Athlon',3000,100,1024,'+','Windows XP Pro', 'Sony 21"',NULL);
insert into KAFEDRA values( 1,'41'); insert into KAFEDRA values( 2,'42'); insert into KAFEDRA values( 3,'43');
insert into ST_GROUP values( 1,'Б8-01',1); insert into ST_GROUP values( 2,'Б8-02',2); insert into ST_GROUP values( 3,'Б8-03',3);
insert into STUDENT values( 1,'Лекшин','Олег','',1); insert into STUDENT values( 2,'Григорьев','Андрей','',1);
insert into STUDENT values( 3,'Зубаревич','Илья','Николаевич',1); insert into STUDENT values( 4,'Зыков','Александр','Сергеевич',1); insert into STUDENT values( 5,'Балашов','Иван','',1);
insert into STUDENT values( 6,'Новиков','Алексей','',1);
insert into STUDENT values( 7,'Горобец','Андрей','Валерьевич',1); insert into STUDENT values( 8,'Витязев','Всеволод','',1);
insert into STUDENT values( 9,'Колосова','Татьяна','',1); insert into STUDENT values( 10,'Маркелов','Василий','',1); insert into STUDENT values( 11,'Степченков','Максим','',1); insert into STUDENT values( 12,'Архангельская','Анна','',1); insert into STUDENT values( 13,'Беликов','Дмитрий','',1); insert into STUDENT values( 14,'Красникова','Светлана', 'Владимировна',1);
insert into STUDENT values( 15,'Бадиков','Александр','',2); insert into STUDENT values( 16,'Ефремова','Юлия','',2); insert into STUDENT values( 17,'Мясумов','Марат','',2); insert into STUDENT values( 18,'Смирнов','Илья','',2); insert into STUDENT values( 19,'Лысюк','Дарья','',2); insert into STUDENT values( 20,'Анашкина','Анна','',2); insert into STUDENT values( 21,'Гилёв','Алексей','',2); insert into STUDENT values( 22,'Лурье','Александр','',2); insert into STUDENT values( 23,'Николаенко','Денис','',2); insert into STUDENT values( 24,'Блинов','Алексей','',2); insert into STUDENT values( 25,'Сергеев','Андрей','',2); insert into STUDENT values( 26,'Гончаров','Евгений','',3);
546
insert into STUDENT values( 27,'Речинский','Алексей','',3); insert into STUDENT values( 28,'Илюхина','Ирина','',3); insert into STUDENT values( 29,'Борщ','Александр','',3); insert into STUDENT values( 31,'Филатов','Сергей','',3); insert into STUDENT values( 32,'Быкадоров','Дмитрий','',3); insert into STUDENT values( 33,'Макаров','Олег','',3);
insert into STUDENT values( 34,'Реутов','Артём','',3);
insert into PROFESSOR values(1,'Лаврентьев','Валерий','Сергеевич',3); insert into PROFESSOR values(2,'Зотов','А','А',1);
insert into PROFESSOR values(3,'Беззубцев','Б','Б',2);
insert into PROFESSOR values(4,'Малюк','Анатолий','Александрович',NULL);
insert into COURSE values(1,'Oracle',1,8,'+','+'); insert into COURSE values(2,'Unix',1,16,'+','-'); insert into COURSE values(3,'C++',9,16,'-','+');
insert into SEMESTER values(1,'осенний'); insert into SEMESTER values(2,'весенний');
insert into DAY values(1,'Понедельник'); insert into DAY values(2,'Вторник'); insert into DAY values(3,'Среда');
insert into DAY values(4,'Четверг'); insert into DAY values(5,'Пятница'); insert into DAY values(6,'Суббота'); insert into DAY values(7,'Воскресенье');
insert into PAIR values(1,to_date('08:45','HH24:Mi'), to_date('10:10','HH24:Mi'));
insert into PAIR values(2,to_date('10:20','HH24:Mi'), to_date('11:45','HH24:Mi'));
insert into PAIR values(3,to_date('12:40','HH24:Mi'), to_date('14:25','HH24:Mi'));
547
insert into PAIR values(4,to_date('14:35','HH24:Mi'), to_date('16:00','HH24:Mi'));
insert into PAIR values(5,to_date('16:10','HH24:Mi'), to_date('17:35','HH24:Mi'));
insert into PAIR values(6,to_date('17:45','HH24:Mi'), to_date('19:10','HH24:Mi'));
insert into PAIR values(7,to_date('19:20','HH24:Mi'), to_date('20:45','HH24:Mi'));
insert into PAIR values(8,to_date('20:55','HH24:Mi'), to_date('22:20','HH24:Mi'));
insert into SCHEDULE values(1, 2003,1,1,1,1,2,1,1); insert into SCHEDULE values(2, 2003,1,1,1,1,2,1,2); insert into SCHEDULE values(3, 2003,1,1,2,1,2,2,3); insert into SCHEDULE values(4, 2003,1,1,2,1,2,2,4); insert into SCHEDULE values(5, 2003,1,1,3,1,2,4,2); insert into SCHEDULE values(6, 2003,1,1,3,1,2,5,4);
insert into SCHEDULE values(7, 2003,2,2,1,2,2,4,3); insert into SCHEDULE values(8, 2003,2,2,1,2,2,4,4); insert into SCHEDULE values(9, 2003,2,2,2,2,2,1,3); insert into SCHEDULE values(10,2003,2,2,2,2,2,1,4); insert into SCHEDULE values(11,2003,2,2,3,2,2,1,5); insert into SCHEDULE values(12,2003,2,2,3,2,2,1,6);
insert into SCHEDULE values(13,2003,3,1,1,4,2,2,3); insert into SCHEDULE values(14,2003,3,1,2,4,2,3,1); insert into SCHEDULE values(15,2003,3,1,3,4,2,5,1);
insert into CLASS values(1,to_date('1302','DDMM'), 12,'-',1); insert into CLASS values(2,to_date('2002','DDMM'), 7,'-',1); insert into CLASS values(3,to_date('2702','DDMM'), 8,'-',1); insert into CLASS values(4,to_date('0703','DDMM'), 10,'-',1); insert into CLASS values(5,to_date('1403','DDMM'), 11,'-',1); insert into CLASS values(6,to_date('2103','DDMM'), 9,'-',1);
insert into CLASS values(7,to_date('1202','DDMM'), 10,'-',10);
548
insert into CLASS values(8,to_date('1902','DDMM'), 8,'-',10); insert into CLASS values(9,to_date('0303','DDMM'), 7,'-',10); insert into CLASS values(10,to_date('0503','DDMM'), 11,'+',10); insert into CLASS values(11,to_date('1003','DDMM'), 12,'-',10); insert into CLASS values(12,to_date('1503','DDMM'), 6,'+',10); insert into CLASS values(13,to_date('2203','DDMM'), 7,'+',10); insert into CLASS values(14,to_date('2903','DDMM'), 10,'+',10);
insert into ERROR values(1,'','Сломался USB порт', '+', 5, 1); insert into ERROR values(2,'','Неисправен процессор', '-', 1, 16); insert into ERROR values(3,'','Сгорел монитор', '+', 8, 30);
СКРИПТ ДЛЯ РАБОТЫ 13
--SCOTT_WITH_OFFICIAL.SQL
DROP TABLE dept CASCADE CONSTRAINT; CREATE TABLE dept
(deptno NUMBER(2) CONSTRAINT pk_dept PRIMARY KEY, dname VARCHAR2(14) ,
loc VARCHAR2(13) ) ;
DROP TABLE emp CASCADE CONSTRAINT; CREATE TABLE emp
(empno NUMBER(4) CONSTRAINT pk_emp PRIMARY KEY, ename VARCHAR2(10),
job VARCHAR2(9),
mgr NUMBER(4) CONSTRAINT emp_self_key REFERENCES emp(empno),
hiredate DATE, sal NUMBER(7,2),
comm NUMBER(7,2),
deptno NUMBER(2) CONSTRAINT fk_deptno REFERENCES dept(deptno));
INSERT INTO dept VALUES (10,'ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES (20,'RESEARCH','DALLAS'); INSERT INTO dept VALUES
(30,'SALES','CHICAGO'); INSERT INTO dept VALUES
549
(40,'OPERATIONS','BOSTON');
INSERT INTO emp VALUES (7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm- yyyy'),5000,NULL,10);
INSERT INTO emp VALUES (7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm- yyyy'),2850,NULL,30);
INSERT INTO emp VALUES (7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm- yyyy'),2450,NULL,10);
INSERT INTO emp VALUES (7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm- yyyy'),2975,NULL,20);
INSERT INTO emp VALUES (7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm- yyyy'),3000,NULL,20);
INSERT INTO emp VALUES (7788,'SCOTT','ANALYST',7566,to_date('13-07-87')- 85,3000,NULL,20);
INSERT INTO emp VALUES (7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm- yyyy'),800,NULL,20);
INSERT INTO emp VALUES (7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm- yyyy'),1600,300,30);
INSERT INTO emp VALUES (7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm- yyyy'),1250,500,30);
INSERT INTO emp VALUES (7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm- yyyy'),1250,1400,30);
INSERT INTO emp VALUES (7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm- yyyy'),1500,0,30);
INSERT INTO emp VALUES (7876,'ADAMS','CLERK',7788,to_date('13-7-87')-51,1100,NULL,20); INSERT INTO emp VALUES
550