User ID Lookup by Name using XXEN_UTIL
I need a utility function that simply returns the numeric user ID (`user_id`) when given an Oracle username.
1 reply
- You must be logged in to reply to this post.
Sign in with LinkedIn or Google to take part.
Home › Discussions › Questions & Answers › User ID Lookup by Name using XXEN_UTIL
Customer · · Questions & Answers · 1 reply
I need a utility function that simply returns the numeric user ID (`user_id`) when given an Oracle username.
You should use the function `XXEN_UTIL.USER_ID(p_user_name in varchar2)`. For example, querying `xxen_util.user_id(‘SYSADMIN’)` returns `0`.
Sign in with LinkedIn or Google to take part.