oracle get session code example

Example: oracle current session details

SELECT sys_context('USERENV', 'SID') FROM DUAL;