longhair | Cauchy Reed-Solomon Block Erasure Code | Messaging library

Being a beginner in SQL oracle, I am working on a table CATS with 4 varchar2 fields country, hair, color and firstItemFound. I am trying to edit a sql request so each time I hit a new tuple name || country || color , I add an attribute 'true' if I did already find this tuple I add an attribute 'false'.

I thought about this :

step 1) Update (select distinct name, country, color from cats) tmp_cats set firstItemFound = true;

step 2) Update cats set firstItemFound = false where firstItemFound is null;

But 1) is not working because you can't update a non physical view. Does there is any work around ? Is it possible to do it in one operation instead of two ?

Here is my table values (firstItemFound column has null values) :

I'm writting a function that sould be able to scrap links from people names contained in an html file. I wanna warn you all beforehand, i know it's ugly, i know it's long, and i also know it's certainly not the most elegant way of doing it. But this is the best i could come up with, since i'm a total beginner in python.

Here's my code: