42.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 42-5 GET_USER_STYLE Function
Parameter | Description |
---|---|
|
The application to set the user style preference. |
|
The user name to the user style preference. |
|
The theme number to set the session style. |
|
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;
Parent topic: APEX_THEME