drop table names;
create table names (nom varchar2(20));
insert into names values (upper('Michel'));
insert into names values (upper('Lucas'));
insert into names values (upper('Theo'));
insert into names values (upper('Thomas'));
insert into names values (upper('Manon'));
insert into names values (upper('Hugo'));
insert into names values (upper('Emma'));
insert into names values (upper('Chloe'));
insert into names values (upper('Maxime'));
insert into names values (upper('Enzo'));
insert into names values (upper('Camille'));
insert into names values (upper('Oceane'));
insert into names values (upper('Antoine'));
insert into names values (upper('Clement'));
insert into names values (upper('Quentin'));
insert into names values (upper('Clara'));
insert into names values (upper('Marie'));
insert into names values (upper('Sarah'));
insert into names values (upper('Nicolas'));
insert into names values (upper('Alexis'));
insert into names values (upper('Ines'));
insert into names values (upper('Romain'));
insert into names values (upper('Louis'));
insert into names values (upper('Lucie'));
insert into names values (upper('Anais'));
insert into names values (upper('Baptiste'));
insert into names values (upper('Nathan'));
insert into names values (upper('Valentin'));
insert into names values (upper('Paul'));
insert into names values (upper('Mathilde'));
insert into names values (upper('Julie'));
insert into names values (upper('Mathis'));
insert into names values (upper('Laura'));
insert into names values (upper('Arthur'));
insert into names values (upper('Pauline'));
insert into names values (upper('Julien'));
insert into names values (upper('Lisa'));
insert into names values (upper('Axel'));
insert into names values (upper('Jade'));
insert into names values (upper('Benjamin'));
insert into names values (upper('Florian'));
insert into names values (upper('Marine'));
insert into names values (upper('Maeva'));
insert into names values (upper('Pierre'));
insert into names values (upper('Dylan'));
insert into names values (upper('Adrien'));
insert into names values (upper('Justine'));
insert into names values (upper('Kevin'));
insert into names values (upper('Mathieu'));
insert into names values (upper('Corentin'));
insert into names values (upper('Anthony'));
insert into names values (upper('Juliette'));
insert into names values (upper('Matteo'));
insert into names values (upper('Emilie'));
insert into names values (upper('Victor'));
insert into names values (upper('Celia'));
insert into names values (upper('Jules'));
insert into names values (upper('Lola'));
insert into names values (upper('Noemie'));
insert into names values (upper('Amandine'));
insert into names values (upper('Louise'));
insert into names values (upper('yanis'));
insert into names values (upper('Elisa'));
insert into names values (upper('Clemence'));
insert into names values (upper('Romane'));
insert into names values (upper('Morgane'));
insert into names values (upper('Marion'));
insert into names values (upper('Margaux'));
insert into names values (upper('Melissa'));
insert into names values (upper('Alicia'));
insert into names values (upper('Jeanne'));
insert into names values (upper('Simon'));
insert into names values (upper('Dorian'));
insert into names values (upper('Raphael'));
insert into names values (upper('Killian'));
insert into names values (upper('Matheo'));
insert into names values (upper('Alice'));
insert into names values (upper('Vincent'));
insert into names values (upper('Gabriel'));
insert into names values (upper('Samuel'));
insert into names values (upper('Jeremy'));
insert into names values (upper('Bastien'));
insert into names values (upper('Amelie'));
insert into names values (upper('Margot'));
insert into names values (upper('Elise'));
insert into names values (upper('Damien'));
insert into names values (upper('Tristan'));
insert into names values (upper('Carla'));
insert into names values (upper('Thibault'));
insert into names values (upper('Martin'));
insert into names values (upper('Remi'));
insert into names values (upper('Lena'));
insert into names values (upper('Loic'));
insert into names values (upper('Mohamed'));
insert into names values (upper('Matthieu'));
insert into names values (upper('Jordan'));
insert into names values (upper('Ambre'));
insert into names values (upper('Coralie'));
insert into names values (upper('Laurine'));
insert into names values (upper('Noah'));
insert into names values (upper('Maelle'));
insert into names values (upper('Flavie'));
insert into names values (upper('Agathe'));
insert into names values (upper('Elodie'));
insert into names values (upper('Mael'));
insert into names values (upper('Rayan'));
insert into names values (upper('Anna'));
insert into names values (upper('Antonin'));
insert into names values (upper('Evan'));
insert into names values (upper('Robin'));
insert into names values (upper('Aurelien'));
insert into names values (upper('Berkant'));
insert into names values (upper('Beverly'));
insert into names values (upper('Brad'));
insert into names values (upper('Calixte'));
insert into names values (upper('Celio'));
insert into names values (upper('Chaina'));
insert into names values (upper('Cleophee'));
insert into names values (upper('Dania'));
insert into names values (upper('Fadwa'));
insert into names values (upper('Faouzi'));
insert into names values (upper('Feyza'));
insert into names values (upper('Georgia'));
insert into names values (upper('Gibril'));
insert into names values (upper('Harmony'));
insert into names values (upper('Ilane'));
insert into names values (upper('Inas'));
insert into names values (upper('Isra'));
insert into names values (upper('Kelia'));
insert into names values (upper('Lauriana'));
insert into names values (upper('Leona'));
insert into names values (upper('Leyna'));
insert into names values (upper('Madyson'));
insert into names values (upper('Mahmoud'));
insert into names values (upper('Makan'));
insert into names values (upper('Mattieu'));
insert into names values (upper('Maxens'));
insert into names values (upper('Medy'));
insert into names values (upper('Melynda'));
insert into names values (upper('Mira'));
insert into names values (upper('Miriam'));
insert into names values (upper('Moira'));
insert into names values (upper('Myrtille'));
insert into names values (upper('Najib'));
insert into names values (upper('Ocean'));
insert into names values (upper('Patxi'));
insert into names values (upper('Precilia'));
insert into names values (upper('Sally'));
insert into names values (upper('Shawn'));
insert into names values (upper('Shyrel'));
insert into names values (upper('Tiffaine'));
insert into names values (upper('Timon'));
insert into names values (upper('Umit'));
insert into names values (upper('Warda'));
insert into names values (upper('Williams'));
insert into names values (upper('Ylann'));
insert into names values (upper('Youen'));
insert into names values (upper('Zidane'));
insert into names values (upper('CYBELLIA'));
insert into names values (upper('Adama'));
insert into names values (upper('Adelina'));
insert into names values (upper('Antton'));
insert into names values (upper('Auxence'));
insert into names values (upper('Cyrian'));
insert into names values (upper('Damian'));
insert into names values (upper('Danielle'));
insert into names values (upper('Darlene'));
insert into names values (upper('Darryl'));
insert into names values (upper('Edgard'));
insert into names values (upper('Elya'));
insert into names values (upper('Evie'));
insert into names values (upper('Farida'));
insert into names values (upper('France'));
insert into names values (upper('Gwenn'));
insert into names values (upper('Halim'));
insert into names values (upper('Jacob'));
insert into names values (upper('Julianna'));
insert into names values (upper('Kaelig'));
insert into names values (upper('Keryan'));
insert into names values (upper('Kevan'));
insert into names values (upper('Kiliann'));
insert into names values (upper('Louanna'));
insert into names values (upper('Mahel'));
insert into names values (upper('Maitena'));
insert into names values (upper('Majda'));
insert into names values (upper('Mano'));
insert into names values (upper('Marieme'));
insert into names values (upper('Marissa'));
insert into names values (upper('Mark'));
insert into names values (upper('Marley'));
insert into names values (upper('Mathew'));
insert into names values (upper('Mattys'));
insert into names values (upper('Mauryne'));
insert into names values (upper('Melvil'));
insert into names values (upper('Melvina'));
insert into names values (upper('Rachida'));
insert into names values (upper('Ramazan'));
insert into names values (upper('Roberto'));
insert into names values (upper('Seyma'));
insert into names values (upper('Sofien'));
insert into names values (upper('Sohane'));
insert into names values (upper('Souhaila'));
insert into names values (upper('Stevan'));
insert into names values (upper('Suleyman'));
insert into names values (upper('Sunny'));
insert into names values (upper('Sylvia'));
insert into names values (upper('Tamera'));
insert into names values (upper('Tasnim'));
insert into names values (upper('Yahya'));
insert into names values (upper('Yanice'));
insert into names values (upper('Zara'));
insert into names values (upper('Allya'));
insert into names values (upper('Allyson'));
commit;
alter table names add (id number(5));
declare 
   i binary_integer := 0;
begin
   for rec in (select nom from names) loop
      i := i + 1;
      update names set id=i where nom=rec.nom;
   end loop;
end;
/
commit;