适用于Oracle的MySQL等效会话变量 [英] MySQL equivalent session variable for Oracle

问题描述

在MySQL中，我可以使用单个@创建访问会话变量. 初始化示例:

In MySQL, I can create an access a session variable by using a single @. Example initialization:

set @myVar = true;

一些包含以下代码的触发器:

Some trigger containing this code:

if (@myVar is not true) then
  execute something

Oracle 10g中的等效项是什么?

What is the equivalent in Oracle 10g?

推荐答案

SQL> EXEC DBMS_SESSION.SET_CONTEXT('CLIENTCONTEXT', 'myvar', 'myvalue');

PL/SQL procedure successfully completed

SQL> SELECT SYS_CONTEXT('CLIENTCONTEXT', 'myvar') FROM dual;

SYS_CONTEXT('CLIENTCONTEXT','M
--------------------------------------------------------------------------------
myvalue

这篇关于适用于Oracle的MySQL等效会话变量的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！