code to check the password at least one upper case letter
I receive a task to setup so it can check the complexity of the password. I use utlpwdmg.sql to modify to meet the requirement at our site. The script does not check the password to have at least one upper case letter. I googled it and so far it said that oracle does not have the capability of checking the case sensitive until 11g patch. Our site database is 10g. Is there workaround or suggestion of what I can do or look. I truthly appreciate it.