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

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

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (65, 'D@sZW', '2011-08-31 01:14:47');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (66, 'D], D00XXPHu]TUH 8,w', '2011-08-21 06:19:40');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (67, '|~m]#5H;No^', '2011-08-28 13:18:26');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (68, '6Ca4ztT-q?YFYuf9?', '2011-08-25 12:12:29');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (69, 'Gg@D,4g.#Ign2fu&', '2011-09-13 02:26:29');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (70, 'Hv', '2011-10-05 10:39:19');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (71, '[a/qd', '2011-10-02 04:56:38');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (72, 'E5{FX\ms>+)Gy%7>}31z', '2011-08-19 18:39:32');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (73, 'wdZ+ntTHfgK', '2011-09-14 23:41:25');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (74, ']-uEe)(', '2011-08-11 15:58:10');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (75, 'mrIT.D{xq:<^|fI', '2011-08-26 09:46:37');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (76, '1@}7duxq#z8NVCA.dNK', '2011-09-23 22:53:33');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (77, '7]u1N#<oJv%6_', '2011-10-01 15:55:56');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (78, '1>P#F/,|', '2011-10-05 21:17:10');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (79, 'YX?+kis+>', '2011-08-31 22:02:24');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (80, ';$4,&]Rj@+mWZvj>/', '2011-08-19 13:53:09');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (81, ';} 9Cw@2#|', '2011-09-28 14:53:52');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (82, 'WOmh!O:WkT', '2011-09-22 21:50:52');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (83, ' oG`I=Qt,P', '2011-09-22 19:24:28');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (84, 'BGx1!"R%#pk\', '2011-09-15 09:54:48');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (85, '|O=EL0"8BotPO2X7Ms', '2011-09-13 08:57:32');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (86, ',DPw7G', '2011-09-27 04:33:24');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (87, 'Im`A6%fV)r~O', '2011-09-07 22:22:27');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (88, '{x^v~mk', '2011-09-08 20:23:45');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (89, '<jE.vw.UOPo3L@$WX', '2011-09-14 06:44:41');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (90, '*', '2011-09-01 16:12:04');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (91, '''', '2011-08-13 23:49:26');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (92, '$#nJl''|', '2011-08-27 16:23:02');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (93, 'Y$ZQNlxhD6_9`zwkRb5C', '2011-08-21 13:35:16');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (94, '*I1&y|gd', '2011-08-09 11:42:22');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (95, 'Gwra-H*_K', '2011-09-18 16:04:27');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (96, '&-xmJDx{Stun;0sqJ*Z', '2011-09-23 19:36:47');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (97, 'S[5', '2011-09-21 13:31:03');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (98, 'M:kU5R', '2011-09-11 17:07:14');

INSERT INTO PEOPLE (ID, NAME, DT_BIRTH) VALUES (99, 'wN#NL,ym>f[2m#', '2011-08-15 09:07:51');

COMMIT WORK;

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (1, 1, 1);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (1, 2, 2);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (2, 3, 1);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (2, 4, 2);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (3, 5, 1);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (3, 6, 2);

Скачать файл