generate random string

aşağıdaki örneklerdeki gibi random (rastgele) string oluşturabiliriz;

--tabloyu random data ile cogaltiyoruz 
begin
 for j in 1..100 loop
 for i in 1..100 loop
 insert into data_tablo1 values(DBMS_RANDOM.STRING('U',300));
 end loop;
 commit;
 end loop;
end;

-- tabloyu olusturdugumuz data ile 10*10 kez cogaltiyoruz 
begin
 for j in 1..10 loop
 for i in 1..10 loop
 insert into data_tablo2 select * from data_tablo1;
 end loop;
 commit;
 end loop;
end;

select DBMS_RANDOM.STRING('A',8) from dual;


update data_tablo2 set no=DBMS_RANDOM.STRING('U',100);

 create or replace function Random_String(p_char varchar2, p_length number)
 return varchar2
 is
 l_res varchar2(256);
 begin
 select substr(listagg(substr(p_char, level, 1)) within group(order by dbms_random.value), 1, p_length)
 into l_res
 from dual
 connect by level <= length(p_char);
 return l_res;
 end;

select Random_String('AbcDe#G1234567', 8) res
 from dual
 connect by level <= 8;