文档下载 文档下载导航
设为首页 | 加入收藏
搜索 请输入内容:  
 导航当前位置: 文档下载 > 所有分类 > 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

fnd_id_flex_structures_tl f4,

fnd_id_flex_structures_tl f5,

fnd_id_flex_structures_tl f6,

hr_organization_information o2,

hr_organization_information o3,

hr_organization_information o4

WHERE o.organization_id = ot.organization_id

AND ot.LANGUAGE = USERENV ('LANG')

....

....

AND f1.LANGUAGE = USERENV ('LANG')

....

....

AND f3.LANGUAGE = USERENV ('LANG')

....

....

AND f6.LANGUAGE = USERENV ('LANG')

WITH READ ONLY;

I have only displayed the relevant lines from the view.

Now If I check the default language set on the Oracle session using, SELECT USERENV ('LANGUAGE') "Language"

FROM DUAL;

We shall now change the session language using

ALTER SESSION SET nls_language='AMERICAN'

After executing that you will get the message

Now let us check the session language .

How to set context in a SQL session in Oracle Apps

上一页第4页

你可能喜欢

热门文档

相关文档

  • 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