Tag Archives: sys_context paketi

Sys_contetxt paketi

Sistemden istediğimiz önemli bilgileri bulmamız açısından sys_context pakatei son derece uygundur. CONNECT OE/passwordSELECT SYS_CONTEXT (‘USERENV’, ‘SESSION_USER’)FROM DUAL;SYS_CONTEXT (‘USERENV’, ‘SESSION_USER’)——————————————————OESELECT sys_context(‘USERENV’,’CLIENT_IDENTIFIER’) FROM dual;exec dbms_session.set_identifier(USER’ ‘ SYSTIMESTAMP);SELECT sys_context(‘USERENV’,’CLIENT_IDENTIFIER’) FROM dual; SELECT sys_context(‘USERENV’, ‘CURRENT_SCHEMA’) FROM dual; SELECT sys_context(‘USERENV’, ‘DB_DOMAIN’) FROM dual; SELECT sys_context(‘USERENV’, … Continue reading

| Tagged | Leave a comment