SQL statement for Oracle user password expiration _oracle

Nonsense not to say, directly to everyone to write SQL statements, of course, there are many kinds of writing, I also just to share one of the solutions, have different views of the can leave a message oh.

Oracle's password is valid for a period of validity, and sometimes you will see a statement that the current password expires:

SELECT * from Dba_profiles s WHERE s.profile= ' DEFAULT ' and resource_name= ' password_life_time ';

Change the time limit for passwords to unrestricted:

ALTER profile DEFAULT LIMIT Password_life_time Unlimited;

The above to share the Oracle user password expiration of the SQL statement, I hope to help.