[Hint] Secure password generator

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 09 Aug 2005 4:24 pm

This SQL generates a string of numeric characters and 2 digits 4.
Code: Select all
SELECT  dbms_random.string('U', 2) ||
  TRUNC(dbms_random.VALUE(1000, 9999)) senha
FROM dual;
Example:
Code: Select all
SQL> SELECT  dbms_random.string('U', 2) ||
  2    TRUNC(dbms_random.VALUE(1000, 9999)) senha
  3  FROM dual
  4  /

SENHA
-------------------------------------------------
CL9523

SQL> /

SENHA
-------------------------------------------------
IM8240

SQL> /

SENHA
-------------------------------------------------
YG1879

SQL>
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


Return to SQL

Who is online

Users browsing this forum: No registered users and 4 guests