Tag Archives: Oracle SQL

SQL Method to generate random Date or text in Oracle SQL

This function will provide a random string with uppercase and lowercase characters create or replace function random_str(v_length number) return varchar2 is my_str varchar2(4000); begin for i in 1..v_length loop my_str := my_str || dbms_random.string( case when dbms_random.value(0, 1) < 0.5 … Continue reading

Posted in Oracle PL/SQL | Tagged , | Leave a comment