Mega Code Archive

 

Categories / Oracle PLSQL / System Packages

 

Use dbms_random string to create random string

SQL> SQL> SQL> exec dbms_output.put_line( dbms_random.string( 'A', 20 ) ); iRhhzYvyWLroMPNCvSdx PL/SQL procedure successfully completed. SQL> exec dbms_output.put_line( dbms_random.string( 'x', 20 ) ); V5HN9YL3C6GJN9BNP4R9 PL/SQL procedure successfully completed. SQL> exec dbms_output.put_line( dbms_random.string( 'P', 20 ) ); w6aH% ZB[3bjH[;x;6h@ PL/SQL procedure successfully completed. SQL> exec dbms_output.put_line( dbms_random.string( 'l', 20 ) ); rjncmdlykahvpgjyecax PL/SQL procedure successfully completed. SQL> exec dbms_output.put_line( dbms_random.string( 'u', 20 ) ); EHXUUTMYMBAJMHIKKDJM PL/SQL procedure successfully completed. SQL> SQL> SQL> --