Retrieve User Id from oracle session

By Santhosh N

This explains how to retrieve the user id from the session in oracle

There is a function by the name "user" to retrieve the user id from the current oracle session

Query: SELECT user FROM dual;

This gives the current user id from the current oracle session.

Related FAQs

IsNumeric in Oracle Database

Used to check if the column value is in numeric format

Retrieve User Id from oracle session (1615 Views)