One of the many useful scalar functions in Oracle is the
SYS_CONTEXT function. This function permits you to obtain data from a "namespace". Oracle provides
USERENV namespace that contains data such as your user name and the database to which you are connected. Oracle also provides a
SYS_SESSION_ROLES that can tell you if you have been granted a certain role (a set of privileges).
To learn how to use the
SYS_CONTEXT function in Oracle, follow these steps:
Resourcerole. We can confirm this fact as shown below: