create table tournois ( numero number(2,0) constraint pktournoi primary key, alias1 char(5), alias2 char(5), res1 number(2,0), res2 number(2,0) ); insert into tournois values(1, 'Barak','Jones',5,4); insert into tournois values(2, 'Jones','Barak',7,3); insert into tournois values(3, 'Jones','Musta',4,6); insert into tournois values(4, 'Jones','Balir',5,5); insert into tournois values(5, 'Barak','Musta',3,7); insert into tournois values(6, 'Barak','Balir',5,5); insert into tournois values(7, 'Barak','Simba',2,8); insert into tournois values(8, 'Simba','Barak',7,3); insert into tournois values(10, 'Simba','Balir',6,4); commit;