14:13:11 SQL> select user,uid from dual;USER UID
------------------------------ ----------
TEMP 24已用时间: 00: 00: 00.16
14:13:16 SQL> select Sys_context('userenv','sessionid') from dual;SYS_CONTEXT('USERENV','SESSIONID')
--------------------------------------------------------------------------
5358已用时间: 00: 00: 00.32
14:13:43 SQL>
------------------------------ ----------
TEMP 24已用时间: 00: 00: 00.16
14:13:16 SQL> select Sys_context('userenv','sessionid') from dual;SYS_CONTEXT('USERENV','SESSIONID')
--------------------------------------------------------------------------
5358已用时间: 00: 00: 00.32
14:13:43 SQL>
我想知道
比如
ALTER SESSION SET NLS_DATE_FORMAT='YYYY-DD-MM';
当前SESSION得NLS_DATE_FORMAT格式?
---------------------------------------------------------------------------
yyyy-mm-dd hh24:mi:ss已用时间: 00: 00: 00.16
14:20:58 SQL>
查一下有关SYS_CONTEXT的文档