create table update_test
(
company varchar2(50),
companyid varchar2(20),
prodid varchar2(20),
flag varchar2(10)
)
insert into update_test values ('centOSX','C11','21X','T');
insert into update_test values ('centOSX','C11','25X','T');
insert into update_test values ('centOSX','C11','29X','T');
insert into update_test values ('dosOSX','d19','21HH','F');
insert into update_test values ('dosOSX','d19','25HH','F');
insert into update_test values ('dosOSX','d19','29HH','F');
insert into update_test values ('asusOSX','A11','21X','T');
insert into update_test values ('asusOSX','A11','25X','T');
insert into update_test values ('asusOSX','A11','29X','T');
insert into update_test values ('legoOSX','L11','21X','T');
insert into update_test values ('legoOSX','L11','25X','T');
insert into update_test values ('legoOSX','L11','29X','T');