Oracle – Display Contextual Information in sqlplus session (using sys_context)

Find username, db_name etc. from sqlplus session

select sys_context ('USERENV', 'SESSION_USER') from dual;

select sys_context ('USERENV', 'DB_NAME') from dual;

Leave a Reply

Your email address will not be published. Required fields are marked *