26.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 26-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;