Password Verify Function

SELECT profile, limit
FROM dba_profiles,
(SELECT limit AS def_pwd_verify_func
FROM dba_profiles
WHERE resource_name = 'PASSWORD_VERIFY_FUNCTION'
AND profile = 'DEFAULT')
WHERE resource_name='PASSWORD_VERIFY_FUNCTION'
AND REPLACE(limit,'DEFAULT',def_pwd_verify_func) in
('UNLIMITED','NULL');