Информатика и выч. техника \ Базы данных

Базы данных SQL-DDL и SQL-DML. Изучение транзакций. Программирование на языке SQL. Консольное приложение (Цикл лабораторных работ). Вариант № 1, страница 14

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 10, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 11, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 12, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 15, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 16, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 17, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 18, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 20, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 21, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 22, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 23, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 25, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 26, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 27, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 29, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 30, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 31, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 32, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 33, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 34, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 98, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 38, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 39, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 42, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (2, 43, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 44, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 45, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 46, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 48, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (3, 49, '2011-06-01 00:00:00');

INSERT INTO STATUS_HISTORY (STATUS_ID, PERSON_ID, DT_CHANGE) VALUES (1, 50, '2010-06-01 00:00:00');

COMMIT WORK;

INSERT INTO SUMMONS (ID, DT_CREATE, DT_SUMMON, PERSON_ID) VALUES (56, '2011-06-14 00:00:00', '2011-06-21 00:00:00', 6);

INSERT INTO SUMMONS (ID, DT_CREATE, DT_SUMMON, PERSON_ID) VALUES (57, '2011-06-14 00:00:00', '2011-06-21 00:00:00', 13);

INSERT INTO SUMMONS (ID, DT_CREATE, DT_SUMMON, PERSON_ID) VALUES (58, '2011-06-14 00:00:00', '2011-06-21 00:00:00', 14);

INSERT INTO SUMMONS (ID, DT_CREATE, DT_SUMMON, PERSON_ID) VALUES (59, '2011-06-14 00:00:00', '2011-06-21 00:00:00', 19);

INSERT INTO SUMMONS (ID, DT_CREATE, DT_SUMMON, PERSON_ID) VALUES (60, '2011-06-14 00:00:00', '2011-06-21 00:00:00', 24);

Скачать файл