select dbms_random.random from dual; 


select dbms_random.value(1,10) from dual; 


select round(dbms_random.value(1,10),0) from dual;



declare
    n pls_integer;
begin
    n := dbms_random.value(1,10);
    dbms_output.put_line('A random szám: ' || n);
end;


create or replace function RANDOM return number is 
    a number; 
begin
    select round(dbms_random.value(1,10)) into a from dual;
    return a;
end;
 
select RANDOM from dual; 

declare 
r number(2);
begin
select RANDOM into r from dual;
dbms_output.put_line('random: ' || r);
end;



select dbms_random.string('L', 20) str from dual;
select dbms_random.string('U', 20) str from dual;