random data

INSERT INTO emp(id, name, surname, salary)
SELECT ROWNUM, DBMS_RANDOM.string('A', 7), DBMS_RANDOM.string('A', 10), DBMS_RANDOM.VALUE(2, 9) * 1000
FROM dual
CONNECT BY LEVEL <= 100;