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');