DROP TABLE rally;
CREATE TABLE rally ( 
  név          VARCHAR2(25), 
  nemzetiség   VARCHAR2(20),
  feladatkör   VARCHAR2(9),
  minősítés    NUMBER(3),
  partner      VARCHAR2(25)
);

INSERT INTO rally VALUES ('Gyula'    ,'HUN'   ,'PILOT'    ,50,   '---');
INSERT INTO rally VALUES ('White'    ,'GBR'   ,'PILOT'    ,72,   '---');
INSERT INTO rally VALUES ('van Glut' ,'NED'   ,'PILOT'    ,60,   '---');
INSERT INTO rally VALUES ('Sándor'   ,'HUN'   ,'PILOT'    ,67,   '---');
INSERT INTO rally VALUES ('Piere'    ,'FRA'   ,'PILOT'    ,57,   '---');
INSERT INTO rally VALUES ('Miklós'   ,'HUN'   ,'PILOT'    ,80,   '---');
INSERT INTO rally VALUES ('Wraclaw'  ,'POL'   ,'NAVIGATOR',55,   '---');
INSERT INTO rally VALUES ('Nitzky'   ,'POL'   ,'NAVIGATOR',76,   '---');
INSERT INTO rally VALUES ('ONeil'    ,'GBR'   ,'NAVIGATOR',67,   '---');
INSERT INTO rally VALUES ('Kertész'  ,'HUN'   ,'NAVIGATOR',55,   '---');

