insert into params(object_id, attr_id, number_value) values (10,10,222222);
insert into params(object_id, attr_id, number_value) values (20,10,222223);
insert into params(object_id, attr_id, number_value) values (30,10,222224);
insert into params(object_id, attr_id, number_value) values (40,10,222225);
/* Emp-> job_id */
insert into params(object_id, attr_id, number_value) values(1001,11,20001);
insert into params(object_id, attr_id, number_value) values(1002,11,20001);
insert into params(object_id, attr_id, number_value) values(1003,11,20001);
insert into params(object_id, attr_id, number_value) values(1004,11,20002);
insert into params(object_id, attr_id, number_value) values(1005,11,20002);
insert into params(object_id, attr_id, number_value) values(1006,11,20003);
insert into params(object_id, attr_id, number_value) values(1007,11,20003);
insert into params(object_id, attr_id, number_value) values(1008,11,20003);
insert into params(object_id, attr_id, number_value) values(1009,11,20004);
insert into params(object_id, attr_id, number_value) values(1010,11,20005);
insert into params(object_id, attr_id, number_value) values(1011,11,20005);
insert into params(object_id, attr_id, number_value) values(1012,11,20006);
insert into params(object_id, attr_id, number_value) values(1013,11,20007);
insert into params(object_id, attr_id, number_value) values(1014,11,20008);
insert into params(object_id, attr_id, number_value) values(1015,11,20008);
/* Emp-> dep */
insert into params(object_id, attr_id, number_value) values(1001,12,10);
insert into params(object_id, attr_id, number_value) values(1002,12,10);
insert into params(object_id, attr_id, number_value) values(1003,12,10);
insert into params(object_id, attr_id, number_value) values(1004,12,10);
insert into params(object_id, attr_id, number_value) values(1005,12,20);
insert into params(object_id, attr_id, number_value) values(1006,12,30);
insert into params(object_id, attr_id, number_value) values(1007,12,20);
insert into params(object_id, attr_id, number_value) values(1008,12,30);
insert into params(object_id, attr_id, number_value) values(1009,12,30);
insert into params(object_id, attr_id, number_value) values(1010,12,10);
insert into params(object_id, attr_id, number_value) values(1011,12,20);
insert into params(object_id, attr_id, number_value) values(1012,12,20);
insert into params(object_id, attr_id, number_value) values(1013,12,20);
insert into params(object_id, attr_id, number_value) values(1014,12,40);
insert into params(object_id, attr_id, number_value) values(1015,12,40);
commit;
7.5 Результаты заполнения таблиц
Таблица OBJECT_TYPE
OBJECT_TYPE_ID |
NAME |
DESCRIPTION |
1 |
emp |
Employee |
2 |
job |
Job |
3 |
dept |
Department |
Таблица OBJECTS
OBJECT_ID |
OBJECT_TYPE_ID |
NAME |
1012 |
1 |
Irene Mikkil |
1001 |
1 |
Genry Kurtis |
1002 |
1 |
Alan Smith |
1003 |
1 |
Bob Marly |
1004 |
1 |
Jack Carter |
1005 |
1 |
Tony Stark |
1006 |
1 |
Jeff Blue |
1007 |
1 |
Piter Griffin |
1008 |
1 |
Gregory Simpson |
1009 |
1 |
Shanta Vollman |
1010 |
1 |
Kevin Mourgos |
1011 |
1 |
Julia Nayer |
1013 |
1 |
James Landry |
1014 |
1 |
Steven Markle |
1015 |
1 |
Laura Bissot |
20001 |
2 |
Administration Assistant |
20002 |
2 |
Finance Manager |
20003 |
2 |
Accountant |
20004 |
2 |
Accounting Manager |
20005 |
2 |
Public Accountant |
20006 |
2 |
Sales Manager |
20007 |
2 |
Sales Representative |
20008 |
2 |
Purchasing Manager |
20009 |
2 |
Purchasing Clerk |
20010 |
2 |
Stock Manager |
20011 |
2 |
Stock Clerk |
20012 |
2 |
Shipping Clerk |
20013 |
2 |
Programmer |
20014 |
2 |
Marketing Manager |
20015 |
2 |
Marketing Representative |
20016 |
2 |
Human Resources Representative |
20017 |
2 |
Public Relations Representative |
10 |
3 |
Marketing |
20 |
3 |
Purchasing |
30 |
3 |
Human Resources |
40 |
3 |
Shipping |
Уважаемый посетитель!
Чтобы распечатать файл, скачайте его (в формате Word).
Ссылка на скачивание - внизу страницы.