Random

Very good way to duplicate test data is using random function. Syntax for the same is as below:

select dbms_random.value from dual