INSERT INTO T_J_PRATIQUE
SELECT DISTINCT ADR_ID, SPT_ID
FROM   T_ADHERENT
       INNER JOIN T_SPORT
          ON CAST((ADR_ID + 100 * SPT_ID) * dbms_random.value AS VARCHAR(16)) LIKE '%567%'
order by adr_id;