The PL/SQL package DBMS_RANDOM can generate random text and date values as well as numbers ... For integers in a given range, add the arguments low_value and high_value, and truncate the decimals ...