oracle sql命令求助

soccer

select sid,serial#,status from v$session where audsid=userenv('sessionid');

谁可以告诉我这是查询什么的命令。

还有查询建表的命令，类似于mysql里的show create tables.

谢谢啦

blue_stone

Post by soccer
select sid,serial#,status from v$session where audsid=userenv('sessionid');

查询的是当前会话的信息，使用desc v$session可以查看v$session这个数据字典所有列。

Post by soccer

还有查询建表的命令，类似于mysql里的show create tables.

谢谢啦

使用oracle企业管理器可以实现

dancingpig

select table_name from user_tables;---查询当前用户schema下的所有表
select table_name from all_tables;---查询当前用户能够访问的所有表
select table_name from dba_tables;---数据库中所有的表，只有sys用户和有dba角色权限的用户可以访问

soccer

select sid,serial#,status from v$session where audsid=userenv('sessionid');

audsid这个字段是什么意思？ sessionid是代表什么意思？userenv函数和是什么意思吗？


谢谢，嘿嘿

dancingpig

USERENV ( 'parameter' )
USERENV returns information about the current session. This information can be useful for writing an application-specific audit trail table or for determining the language-specific characters currently used by your session. You cannot use USERENV in the condition of a CHECK constraint.


Table 6-3  Parameters of the USERENV Function
Parameter Return Value
CLIENT_INFO
CLIENT_INFO returns up to 64 bytes of user session information that can be stored by an application using the DBMS_APPLICATION_INFO package.

Caution: Some commercial applications may be using this context value. Check the applicable documentation for those applications to determine what restrictions they may impose on use of this context area.

See Also:

Oracle9i Database Concepts for more on application context
CREATE CONTEXT and SYS_CONTEXT

ENTRYID
ENTRYID returns available auditing entry identifier. You cannot use this attribute in distributed SQL statements. To use this keyword in USERENV, the initialization parameter AUDIT_TRAIL must be set to TRUE.

ISDBA
ISDBA returns 'TRUE' if the user has been authenticated as having DBA privileges either through the operating system or through a password file.

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

LANGUAGE
LANGUAGE returns the language and territory currently used by your session along with the database character set in this form:

language_territory.characterset


SESSIONID
SESSIONID returns your auditing session identifier. You cannot use this attribute in distributed SQL statements.

TERMINAL
TERMINAL returns the operating system identifier for your current session's terminal. In distributed SQL statements, this attribute 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.

dancingpig

AUDSID

NUMBER
Auditing session ID