ODI Interview Questions and Answers:
We can use below query to get current login user name.
All users sessions we can find in SNP_SESSION table and based on GetSession method we can find the current login user session and passing in where clause condition.
select USER_NAME from SNP_SESSION where SESS_NO = <%=odiRef.getSession("SESS_NO"
We can use below query to get current login user name.
All users sessions we can find in SNP_SESSION table and based on GetSession method we can find the current login user session and passing in where clause condition.
select USER_NAME from SNP_SESSION where SESS_NO = <%=odiRef.getSession("SESS_NO"
No comments:
Post a Comment