41.5 GET_USER_STYLE Function

This function returns the theme style user preference for the user and application. If no user preference is present, NULL is returned.

Syntax

FUNCTION GET_USER_STYLE(
    p_application_id  IN NUMBER           DEFAULT  {current application id},
    p_user            IN VARCHAR2         DEFAULT {current user},
    p_theme_number    IN NUMBER           DEFAULT {current theme number} 
) RETURN NUMBER;

Parameters

Table 41-5 GET_USER_STYLE Function

Parameter	Description
p_application_id	The application to set the user style preference.
p_user	The user name to the user style preference.
p_theme_number	The theme number to set the session style.
RETURN	The theme style ID which is set as a user preference.

Example

The query returns the theme style user preference for the ADMIN user in application 100 and theme 42.

select apex_theme.get_user_style( 100, 'ADMIN', 42 ) from dual;