ACCEPT pad PROMPT "Enter the length of your padding value?" ACCEPT ran PROMPT "Enter the length of your random string value? " ACCEPT rnums PROMPT "Enter the number of rows in the table? (Max Values is limited by the rows in all_objects) :" CREATE TABLE testing_table PCTFREE 99 PCTUSED 1 TABLESPACE tools AS SELECT rownum id, dbms_random.string('X',&ran*dbms_random.value) strval, rpad('x',&pad,'x') padding FROM all_objects WHERE rownum <=&rnums /