Find out when my oracle password will expire
This will display a column named "Expiry
Date" which contains the data you requested:
select * from DBA_USERS;
And ….
will give you the same result but with less clustered and easier to read
output.
USER_USERS won't have PASSWORD and PROFILE information as compared to
DBA_USERS.
NEXT….. If you would like to know EXACTLY when your password expires, use
this:
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
select USERNAME, EXPIRY_DATE from USER_USERS where username='your-user-name';
You will get results not just in date, but also in exact time.
Waterloo, 21-MAR-2023 @12:17 pm, BELGIUM
#database #technologies #tech #digital #oracle # intech #plsql #innovation
