Differences

This shows you the differences between two versions of the page.

--- generate_random_password [2018/12/08 12:49] – created 0.0.0.0
+++ generate_random_password [2024/04/20 17:58] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Generate_random_password ======
+<code>
+with function rndstr(p_len in number) return varchar2 is
+    l_random_string varchar(100);
+begin
+    -- start with a string of between 1 and 9 characters that starts with an alpha
+    select dbms_random.string('a',substr(abs(dbms_random.random),1,1))
+    into   l_random_string
+    from   dual;
+    -- add in a 'safe' non-alphanumeric and more alphanumerics up to the length required
+    l_random_string := l_random_string||'#'||dbms_random.string('x',p_len-(length(l_random_string)+1));
+    return l_random_string;
+end;
+select rndstr(14) from dual
+/
+</code>
 <code>
@@ Line 23: / Line 37: @@
         ELSIF (p_char = 'L') THEN RETURN(get_random_char('abcdefghijklmnopqrstuvwxyz'));
         ELSIF (p_char = 'A') THEN RETURN(get_random_char('ABCDEFGHJKLMNPQRSTUVWXYZabcdefghjklmnopqrstuvwxyz'));
-        ELSIF (p_char = 'N') THEN RETURN(get_random_char('23456789'));
+        ELSIF (p_char = 'N') THEN RETURN(get_random_char('123456789'));
-        ELSIF (p_char = '?') THEN RETURN(get_random_char('#{}[]\|=+-*<>:_$'));
+        ELSIF (p_char = '?') THEN RETURN(get_random_char('#{}[[]]\\|=+-*<>>_$'));
         ELSE RETURN(NULL);
         END IF;
@@ Line 44: / Line 58: @@
 /
 </code>