58.152 WORKSPACE_ACCOUNT_DAYS_LEFT Function
This function returns the number of days remaining before the developer or workspace administrator account password expires. Any authenticated user can run this function in a page request context.
Syntax
APEX_UTIL.WORKSPACE_ACCOUNT_DAYS_LEFT (
p_user_name IN VARCHAR2 )
RETURN NUMBER;
Parameters
Parameter | Description |
---|---|
p_user_name |
The user name of the user account. |
Example
The following example finds the number of days remaining before an Oracle APEX administrator or developer account in the current workspace expires.
DECLARE
l_days_left NUMBER;
BEGIN
FOR c1 IN (SELECT user_name from apex_workspace_apex_users) LOOP
l_days_left := APEX_UTIL.WORKSPACE_ACCOUNT_DAYS_LEFT(p_user_name =>
c1.user_name);
htp.p('Workspace Account:'||c1.user_name||' expires in '||l_days_left||' days.');
END LOOP;
END;
Parent topic: APEX_UTIL