Example: Identifying the User Name
You can identify the session user name with the following statement:
SELECT USER;
The system responds with something like the following.
User ------------------------------ JJ43901
Example: Selecting the User Job Title
The following example selects the job title for the session user.
SELECT JobTitle FROM Employee WHERE Name = USER;