CREATE TABLE t1 AS

SELECT level AS id,

       DBMS_RANDOM.string('x',10) AS code,

       DBMS_RANDOM.string('a',50) AS short_description,

       DBMS_RANDOM.string('a',200) AS long_description

  FROM dual

CONNECT BY level <- 10000;

Generates a table called t1 with 10,000 rows, an auto-generated unique numeric id, a random 10 character uppercase code, a random mixed case short description and a random mixed case long description.

Potential issues with this dataset....

• All values are fixed length rather than variable length