首页 | 互联网 | IT动态 | IT培训 | Cisco | Windows | Linux | Java | .Net | Oracle | 软件测试 | C/C++ | 嵌入式开发 | 存储世界 | 服务器
网络设备 | IDC | 安全 | 求职招聘 | 数字网校 | 网页设计 | 平面设计 | 技术专题 | 电子书下载 | 教学视频 | 源码下载 | 搜索 | 博客 | 论坛
中国IT实验室Oracle频道
中国IT教育
Google
首页 入门基础 安装配置 体系架构 PLSQL 备份恢复 性能调优 开发技术 资讯动态 考试认证 下载 专题 讨论
您现在的位置: 中国IT实验室 >> Oracle >> 开发技术 >> 正文

Oracle 9i SYS_CONTEXT函数的使用方法

        INSTANCE
        The instance identification number of the current instance.

        IP_ADDRESS
        IP address of the machine from which the client is connected.

        ISDBA
        TRUE if you are logged on as SYS.

        LANG
        The ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE' parameter.

        LANGUAGE
        The language and territory currently used by your session, along with the database character set, in the form:language_territory.characterset.

        NETWORK_PROTOCOL
        Network protocol being used for communication, as specified in the 'PROTOCOL=protocol' portion of the connect string.

        NLS_CALENDAR
        The current calendar of the current session.

        NLS_CURRENCY
        The currency of the current session.

        NLS_DATE_FORMAT
        The date format for the session.

        NLS_DATE_LANGUAGE
        The language used for expressing dates.

        NLS_SORT BINARY
        or the linguistic sort basis.

        NLS_TERRITORY
        The territory of the current session.

        OS_USER
        Operating system username of the client process that initiated the database session.

        PROXY_USER
        Name of the database user who opened the current session on behalf of SESSION_USER.

        PROXY_USERID
        Identifier of the database user who opened the current session on behalf of SESSION_USER.

        SESSION_USER
        Database user name by which the current user is authenticated. This value remains the same throughout the duration of the session.

        SESSION_USERID
        Identifier of the database user name by which the current user is authenticated.

        SESSIONID
        The auditing session identifier. You cannot use this option in distributed SQL statements.

        TERMINAL
        The operating system identifier for the client of the current session. In distributed SQL statements, this option returns the identifier for your local session. In a distributed environment, this is supported only for remote SELECT statements, not for remote INSERT, UPDATE, or DELETE operations.

上一页  [1] [2] 

【责编:michael】

中国IT教育

相关产品和培训
文章评论
 友情推荐链接
 认证培训
 专题推荐

 ·关于Java框架技术专题
 ·XML全攻略技术专题
 ·JAVA开源技术介绍专题
 ·Java嵌入式开发之J2ME技术专题
 ·超前体验 Oracle 11g的5个新特性…
 ·揭密使用VB.NET的五个实用技巧
 ·Oracle和SQL Server常用函数对比专题…
 ·展现C#世界 C#程序设计专题…
 ·Java入门 Tomcat的配置技巧精华专题…
 ·Oracle RMAN物理备份技术详解…
 今日更新
 社区讨论
 博客论点
 频道精选
 Oracle频道相关导航