CREATE TABLE DANILO.TESTE2(
CPF VARCHAR2(11),
NOME VARCHAR2(100));
insert into danilo.teste2 values ('93434433443','Sousa');
insert into danilo.teste2 values ('54545454545','Ferreira');
insert into danilo.teste2 values ('99393201832','Cavalcante');
insert into danilo.teste2 values ('13902939392','Silva');

select t2.cpf, t.nome
from (select t.*, rownum as seqnum from danilo.teste2 t) t join
     (select t.*, row_number() over (order by dbms_random.value) as seqnum from danilo.teste2 t) t2 -- TABELA QUE EMBARALHA
     on t.seqnum = t2.seqnum;

     MERGE INTO danilo.teste2 t1
USING (
    SELECT 
        cpf,
        ROW_NUMBER() OVER (ORDER BY DBMS_RANDOM.VALUE) AS random_order
    FROM danilo.teste2
) shuffled_data
ON (1 = 1)
WHEN MATCHED THEN
    UPDATE SET t1.cpf = shuffled_data.cpf;

MERGE INTO danilo.teste2 dst
USING (
  select t.rid,
         t2.nome
  from   (
           SELECT ROWNUM AS rn,
                  ROWID AS rid
           FROM   danilo.teste2
         ) t
         INNER JOIN (
           SELECT nome,
                  ROW_NUMBER() OVER (ORDER BY DBMS_RANDOM.VALUE) AS rn
           FROM   danilo.teste2
         ) t2
         ON t.rn = t2.rn
) src
ON (src.rid = dst.ROWID)
WHEN MATCHED THEN
  UPDATE SET nome = src.nome;