System Packages Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. System Packages
  4. 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> --