code to check the password at least one upper case letter

[hrishy]

Hi

Use regular expression for 10g and above
Use ow_pattern for other versions

declare
l_regular_expr VARCHAR2(50) := '[A-Z]';
begin
IF REGEXP_INSTR('password',l_regular_expr)>0 then
  dbms_output.put_line('It Worked');
end if;
end;
 /

declare
l_regular_expr VARCHAR2(50) := '[A-Z]';
begin
IF REGEXP_INSTR('passWord',l_regular_expr)>0 then
  dbms_output.put_line('It Worked');
end if;
end;
/

http://www.dba-oracle.com/oow_gettin...xpressions.pdf