Contents tagged with sessions

  • Oracle Basic Auditing

    Tags: Oracle, audit, auditing, sessions

    selectto_number(substr(dbms_session.unique_session_id,1,4),'XXXX') as mysid,  sys_context('USERENV','SID') as my_current_session, sys_context('USERENV','SESSIONID') as my_audsid,sysdate as now, case … more