Настроение:

uncomfortable

HELP
Люди, выручайте! Нужно написать задачку на pl/sql (oracle 8)

Написать процедуру P_TOTALREP, которая выводит в текстовый файл TOTALREP.TXT текущую дату, фамилию, инициалы сотрудников и список тем экскурсий, отсортированнный по типам. Самостоятельно задать русскоязычные комментарии и ширину колонок так, чтобы общая ширина страницы не превышала 60 знаков. Переход на другую строку внутри колонки должен осуществляться без переноса слов (WORD_WRAPED). В конце процедуры отменить все установки форматирования. В качестве результата предъявить исходный текст подпрограммы и продемонстрировать результаты работы на тестовых данных в таблицах TOPICS, EMP, SQUARE.



CREATE TABLE TOPICS
( TOP_ID NUMBER(5)
CONSTRAINT TOP_ID_PK PRIMARY KEY,
TOPIC VARCHAR2(200),
NOTES VARCHAR2(300),
UNITS NUMBER(3),
TIME NUMBER(5),
TYPE VARCHAR2(3),
WAY_ID NUMBER(4));

-- TOP_ID
-- TOPIC
-- NOTES
-- UNITS
-- TIME
-- TYPE
-- WAY_ID

CREATE TABLE EMP
( EMP_ID NUMBER(5)
CONSTRAINT EMP_ID_PK PRIMARY KEY,
EMP_F_NAME VARCHAR2(50),
EMP_L_NAME VARCHAR2(50),
EMP_LETTERS VARCHAR2(10),
EMP_POST VARCHAR2(50),
EMP_DEP VARCHAR2(50),
EMP_STATUS VARCHAR2(15));



-- EMP_ID
-- EMP_F_NAME
-- EMP_L_NAME
-- EMP_LETTERS
-- EMP_POST
-- EMP_DEP
-- EMP_STATUS



CREATE TABLE TOP_EMP
( TOP_ID NUMBER(5)
CONSTRAINT TOP_ID_FK REFERENCES TOPICS(TOP_ID),
EMP_ID NUMBER(5)
CONSTRAINT EMP_ID_FK REFERENCES EMP(EMP_ID));

CREATE TABLE WAYS
(WAY_ID NUMBER(4)
CONSTRAINT WAY_ID_PK PRIMARY KEY,
WAY_NOTES VARCHAR2(200),
WAY_KEYS VARCHAR2(100));
-- WAY_ID
-- WAY_NOTES
-- WAY_KEYS

CREATE TABLE SQUARE
(S_DAY DATE,
S_EMP_ID NUMBER(5),
S_START_TIME NUMBER(4),
S_BUSY_CODE VARCHAR2(5),
S_TOP_ID NUMBER(5),
S_FOR_OR_RUS NUMBER(1),
S_QUANTITY NUMBER(3),
S_COUNTRY VARCHAR2(25),
S_CITY VARCHAR2(30),
S_ORG VARCHAR2(255),
S_P_FORM NUMBER(2),
S_COST NUMBER(10,2),
S_NUM_OF_ORDER VARCHAR2(10));

-- S_DAY
-- S_EMP_ID
-- S_START_TIME
-- S_BUSY_CODE
-- S_TOP_ID
-- S_FOR_OR_RUS
-- S_QUANTITY
-- S_COUNTRY
-- S_CITY
-- S_ORG
-- S_P_FORM
-- S_COST
-- S_NUM_OF_ORDER

insert into topics (top_id, topic, notes, units, time, type)
values (1, 'ОБЗОРНАЯ ЭКСКУРСИЯ','Французская живопись XVIII века',1,45, 'О');

insert into topics (top_id, topic, notes, units, time, type)
values (2, 'ОБЗОРНАЯ ЭКСКУРСИЯ', 'Творчество Шишкина', 2,90,'ОК');

insert into topics (top_id, topic, notes, units, time, type)
values (3, 'ОБЗОРНАЯ ЭКСКУРСИЯ','Творчество Малевича', 2, 90,'Ц4');

insert into topics (top_id, topic, notes, units, time, type)
values (4, 'ОБЗОРНАЯ ЭКСКУРСИЯ','Морская тема в живописи', 3,135,'Д');

insert into topics (top_id, topic, notes, units, time, type)
values (5, 'ДЕТСКАЯ ЭКСКУРСИЯ','Детская тематика в живописи', 2,90,'Ц3');

insert into topics (top_id, topic, notes, units, time, type)
values (6, 'ПЕРСОНАЛЬНАЯ ЭКСКУРСИЯ','Французская живопись XVIII века', 2,90, 'Ц4');

insert into topics (top_id, topic, notes, units, time, type)
values (7, 'ОБЗОРНАЯ ЭКСКУРСИЯ','Итальянская живопись XVIII века', 2,90, 'КР3');

insert into topics (top_id, topic, notes, units, time, type)
values (8, 'ИНТЕРАКТИВНЫЕ ЭКСКУРСИИ','Русская живопись XVIII века',3,135, 'КР4');

insert into topics (top_id, topic, notes, units, time, type)
values (9, 'ТЕМАТИЧЕСКАЯ ЭКСКУРСИЯ','Русская живопись XVIII века',3,135, 'Ш2');

insert into topics (top_id, topic, notes, units, time, type)
values (10, 'ДЕТСКАЯ ЭКСКУРСИЯ','Русская живопись XVIII века',1,45, 'Ш3');

insert into topics (top_id, topic, notes, units, time, type)
values (11, 'ШКОЛЬНАЯ ЭКСКУРСИЯ','Русская живопись XVII века',1,45, 'Ш3');

insert into topics (top_id, topic, notes, units, time, type)
values (12, 'ПЕРСОНАЛЬНЫЕ ЭКСКУРСИЯ','Английская живопись XVII века',2,90, 'Ш2');

insert into topics (top_id, topic, notes, units, time, type)
values (13, 'КРАЕВЕДЧЕСКИЕ ЭКСКУРСИЯ','Гемания XX века',3,135, 'О');

insert into topics (top_id, topic, notes, units, time, type)
values (14, 'ГРУППОВЫЕ ЭКСКУРСИИ','Русская живопись XVIII века', 2,90, 'КР4');

insert into topics (top_id, topic, notes, units, time, type)
values (15, 'ВИРТУАЛЬНЫЕ ЭКСКУРСИИ','Ипрессионсты', 2,90, 'Ц4');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1001, 'Олег', 'Иванов', 'О.И.', 'Заведующий отделом', 'Отдел связей с общественностью',
'первый');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1002, 'Сергей', 'Смирнов', 'С.С.', 'Старший менеджер', 'Отдел оптовой торговли',
'второй');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1003, 'Антон', 'Петров', 'А.П.', 'специалист', 'Отдел связей',
'по совмещению');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1004, 'Иван', 'Иванов', 'И.И.', 'Флорист', 'Отдел продаж',
'постоянно');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,EMP_STATUS)
values (1005, 'Перт', 'Сергеев', 'П.С.', 'Художник-дизайнер', 'Отдел разработки печатной и упаковочной продукции',
'пятый');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1006, 'Валерий', 'Михайлов', 'В.М.', 'Копирайтер', 'Отдел эфирного промоушена и дизайна',
'шестой');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1007, 'Леонард', 'Абрамов', 'Л.А.', 'Декоратор', 'Отдел декорирования помещений',
'седьмой');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1008, 'Валерий', 'Шлемов', 'В.Ш.', 'Финансовый менеджер', 'Отдел Бюджетирование и бизнес-планирование','восьмой');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP,
EMP_STATUS)
values (1009, 'Александр', 'Павлов', 'А.П.', 'Залоговый инспектор', 'Кредитно-финансовый отдел','девятый');

insert into EMP (emp_id, EMP_F_NAME, EMP_L_NAME, EMP_LETTERS, EMP_POST, EMP_DEP, EMP_STATUS)
values (1010, 'Ивен', 'Петров', 'И.П.', 'Гл. экономист', 'Отдел международных расчетов банка', 'по совмещению');








INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1007);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1004)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (1, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1007);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1004)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (2, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1007);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1004)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (3, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1004);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (4, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1004)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (5, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (6, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (6, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (6, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (6, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (7, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (7, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (7, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (7, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (7, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (7, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1004)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (8, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (9, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (9, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (9, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (9, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (10, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (10, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (10, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (10, 1004)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (10, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (11, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (11, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (11, 1010);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (11, 1010)

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (12, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (12, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (12, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (12, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (12, 1005);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (13, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (13, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (13, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (14, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (14, 1009);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (14, 1001);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (14, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (14, 1005);



INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (15, 1006);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (15, 1008);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (15, 1002);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (15, 1003);

INSERT INTO TOP_EMP (TOP_ID, EMP_ID)
VALUES (15, 1004);

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1006,'Б\Н');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1007,'ОТП');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1008, 10-00,'О', 3, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1009, 'ВЫХ');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1010, 11-00,'Д', 2, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1010, 'Б');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1002, 16-00,'КР3', 1, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1003,'Б\Н');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1004, 12-00,'Ш2', 5, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('27.11.2006', 'DD.MM.YYYY'), 1005, 10-30,'ОК', 15, 1);


INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1006, 10-00,'Ц3', 1, 1);

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1007, 'ОТП');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1008,'Б\Н');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1009, 11-00,'ОК', 2, 1);

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1010, 12-00,'Ц4', 3, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1001, 12-40,'КР4', 4, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1002, 14-00,'Ш3', 5, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1003, 15-00,'О', 6, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1001, 10-00,'ОК', 7, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('28.11.2006', 'DD.MM.YYYY'), 1002, 10-30,'Д', 8, 1);




INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1006, 11-00,'О', 9, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1007, 'ОТП');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1008, 12-00,'ОК', 10, 0 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1009, 12-40,'Д', 11, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1010, 10-00,'Ц3', 12, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1001, 10-30,'Ц4', 13, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1002, 11-30,'КР3', 14, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1003, 14-00,'КР4', 15, 1 );

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1004, 15-30,'Ш2', 1, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('29.11.2006', 'DD.MM.YYYY'), 1005, 10-00,'Ш3', 2, 1 );



INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1006, 10-30,'ОК', 3, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1007, 'Д', 4, 1);

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1008, 12-00,'Ц3', 5, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1009, 12-40,'Ц4', 6, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1010, 'Б\Н');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1001, 10-00,'КР3', 7, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1002, 11-00,'КР4', 8, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1003, 12-00,'Д', 9, 1 );
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1004, 'ВЫХ');
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('30.11.2006', 'DD.MM.YYYY'), 1005,'Б');



INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1006, 10-00,'Д', 10, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1007, 13-00,'О', 11, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1008, 10-30,'Д', 12, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1009, 'Б\Н');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1010, 12-00,'ОК', 13, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1001, 16-30,'Ц3', 14, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1002, 15-00,'ОК', 1, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1003, 'отгул');
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1004, 11-00,'Ц4', 2, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('01.12.2006', 'DD.MM.YYYY'), 1005, 'Б');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1006, 11-00,'Ш2', 3, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1007, 14-00,'ОК', 4, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1008, 'ВЫХ');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1009, 10-00,'Д', 5, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1010, 12-00,'КР3', 6, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1001, 10-00,'Д', 7, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1002, 'Б\Н');
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1003, 17-00,'КР3', 8, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1004, 15-30,'О', 9, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('02.12.2006', 'DD.MM.YYYY'), 1005, 'Б');

INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1006, 12-00,'Ш3', 15, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1007, 'Б\Н');
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1008, 13-00,'Ц4', 1, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1009, 15-00,'Ш2', 3, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1010, 11-00,'КР4', 2, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1001, 'Б\Н');
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1002, 16-30,'Ш2',7, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1003, 10-00,'ОК', 8, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_START_TIME, S_BUSY_CODE, S_TOP_ID, S_FOR_OR_RUS)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1004, 12-40,'Ц3', 4, 1);
INSERT INTO SQUARE (S_DAY, S_EMP_ID, S_BUSY_CODE)
VALUES (TO_DATE('03.12.2006', 'DD.MM.YYYY'), 1005, 'Б');



Очень срочно, до 28го, иначе - гудбай, институт :(
Отблагодарю чем смогу.