文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > IT/计算机 > 计算机软件及应用 > How to set context in a SQL session in Oracle Apps
侵权投诉

How to set context in a SQL session in Oracle Apps

How to set context in a SQL session in Oracle Apps

BEGIN

mo_global.set_policy_context (p_access_mode => 'S', p_org_id => '779');

END;

OR

BEGIN

DBMS_APPLICATION_INFO.set_client_info (client_info => '779'); -- org_id

END;

Tables that contain Multiple Organizations data can be identified by the suffix “_ALL” in the table name. These tables include a column called ORG_ID, which partitions Multiple Organizations data by organization. Every Multiple Organizations table has a corresponding view that

partitions the table’s data by operating unit. Multiple Organizations views partition data by including a DECODE on the internal variable CLIENT_INFO. This variable is set by the security system to the operating unit designated for the responsibility. It operates is a similar way to the LANGUAGE variable, which returns the language of the current session. Note: If accessing data from a Multiple Organizations partitioned object when CLIENT.INFO has not been set (for example, from SQL*Plus), you must use the _ALL table, not the view.

SO_HEADERS_ALL, with its corresponding view SO_HEADERS, is an example of a Multiple Organizations partitioned object.

Multi Language context

In Oracle E-Business, the tables that end with _TL or views that end with _VL are multi language enabled. By default the language that is set is US English denoted as US within the tables. These tables have an entry for each language.

E.g. if you query for the concurrent program, Analyze All Index Column Statistics, you will find as many entries in the table,

fnd_concurrent_programs_tl, as there are languages installed in the instance.

SELECT *

FROM fnd_concurrent_programs_tl

上一页第2页

你可能喜欢

热门文档

相关文档

  • Oracle-SQL跟踪SQL_TRACE

    Oracle-SQL跟踪SQL_TRACE_IT/计算机_专业资料。教你如何设置Oracle的SQL跟踪...SQL> alter session set events '10046 trace name context off'; Session ...

  • ORACLE查看执行计划及SQL TRACE

    ORACLE查看执行计划及SQL TRACE_计算机软件及应用_IT/计算机_专业资料。ORACLE...SQL> alter session set events '10046 trace name context off'; Session ...

  • oracle sql 优化与提高讲义(三)

    oracle sql 优化与提高讲义(三)_IT/计算机_专业资料。Oracle Database : SQL...SQL> alter session set events ‘10046 trace name context forever, l l 4...

  • Oracle9.2 SYS_CONTEXT函数的用法

    Oracle9i(Version 9.2)SYS_CONTEXT 函数的用法 用法...session if it was established by an Oracle ...SQL> 可以明显地看出这个认证明明是应该通过 DATABASE...

  • Oracle session表和process表字段描述

    Oracle session表和process表字段描述_IT认证_资格考试/认证_教育专区。Oracle ...Oracle内部进程的username为空。 COMMAND: session正在执行的SQL Id。1代表create...

  • Oracle常见问题解决办法

    修改 Oracle 字符集的方法 步骤如下: SQL> shutdown...name context forever,level 12'; Session altered....How to Recreate the DB Control Repository ...

  • Oracle SQL培训

    Oracle SQL 培训编制:邓小斌 版本:V1.0 1 Copyright ? Infore Holding , ...grant create session to apps ? grant dba to apps ? CREATE PUBLIC SYNONYM...

  • EBS 问题诊断方法

    SQL_TRACE是Oracle数据库提供的用于进行SQL跟踪的手段, 在某种意义上讲,可以说...alter session set events '10046 trace name context off'; How To Get ...

  • Oracle DB及EBS常用脚本

    (select SQL_HASH_VALUE from v$session where paddr in (select addr from v$process where spid = (select b.oracle_process_id from apps.fnd_concurrent_...

  • ORACLE数据库会话跟踪

    LOGO ORACLE数据库会话跟踪方法四川成享软件—刘德鹏...SESSION SET EVENTS '10053 trace name context ...explain=apps/<password> 3200 sort='(prsela,exee...

站点地图 | 文档上传 | 侵权投诉 | 手机版
本站所有资源均来自互联网,本站只负责收集和整理,均不承担任何法律责任,如有侵权等其它行为请联系我们.
文档下载 Copyright 2013 doc.guandang.net All Rights Reserved.  -  email