WORKSPACE_ACCOUNT_DAYS

53.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

Table 53-116 WORKSPACE_ACCOUNT_DAYS_LEFT 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_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;