42.24 END_USER_ACCOUNT_DAYS_LEFT Function
Returns the number of days remaining before a end user account password expires. This function may be run in a page request context by any authenticated user.
Syntax
APEX_UTIL.END_USER_ACCOUNT_DAYS_LEFT (
p_user_name IN VARCHAR2)
RETURN NUMBER;
Parameters
Table 42-22 END_USER_ACCOUNT_DAYS_LEFT Parameters
Parameter | Description |
---|---|
|
The user name of the user account. |
Example
The following example shows how to use the END_USER_ACCOUNT_DAYS_LEFT
function. Use this function to determine the number of days remaining before an Application Express end user account in the current workspace expires.
DECLARE
l_days_left NUMBER;
BEGIN
FOR c1 IN (SELECT user_name from apex_users) LOOP
l_days_left := APEX_UTIL.END_USER_ACCOUNT_DAYS_LEFT(p_user_name => c1.user_name);
htp.p('End User Account:'||c1.user_name||' expires in '||l_days_left||' days.');
END LOOP;
END;
Parent topic: APEX_UTIL