xxxxxxxxxx
declare
n pls_integer;
begin
n := dbms_random.value(1,10);
end;
xxxxxxxxxx
declare
txt varchar2(128);
n pls_integer;
begin
-- this is how to assign a literal
txt := 'your message here';
-- how to assign the output from a query
SELECT dbms_random.value(1,10) num
into n
FROM dual;
end;