开发者

Retrieving Username Using Oracle Triggers

I am new to using triggers. What function can I use to determine who tripped my trigger?

For example:开发者_如何转开发

Someone updates a row, and I want to know who updated the row.

I am using Oracle 10g.


SELECT sys_context('USERENV', 'SESSION_USER') FROM dual;

or

SELECT sys_context('USERENV', 'SESSION_USERID') FROM dual;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜