[Home] [Help] [Dependency Information]
Object Name: | ICX_SESSIONS# |
---|---|
Object Type: | VIEW |
Owner: | ICX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | Yes | ||
WINDOW_ID | NUMBER | |||
USER_ID | NUMBER | Yes | ||
MODE_CODE | VARCHAR2 | (30) | ||
HOME_URL | VARCHAR2 | (240) | ||
RESPONSIBILITY_APPLICATION_ID | NUMBER | |||
RESPONSIBILITY_ID | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
MENU_ID | NUMBER | |||
FUNCTION_ID | NUMBER | |||
FUNCTION_TYPE | VARCHAR2 | (30) | ||
NLS_LANGUAGE | VARCHAR2 | (30) | ||
LANGUAGE_CODE | VARCHAR2 | (30) | ||
DATE_FORMAT_MASK | VARCHAR2 | (100) | ||
COUNTER | NUMBER | |||
FIRST_CONNECT | DATE | |||
LAST_CONNECT | DATE | |||
NLS_DATE_LANGUAGE | VARCHAR2 | (30) | ||
NLS_NUMERIC_CHARACTERS | VARCHAR2 | (30) | ||
NLS_SORT | VARCHAR2 | (30) | ||
NLS_TERRITORY | VARCHAR2 | (30) | ||
LIMIT_TIME | NUMBER | |||
LIMIT_CONNECTS | NUMBER | |||
DISABLED_FLAG | VARCHAR2 | (1) | ||
PSEUDO_FLAG | VARCHAR2 | (1) | ||
PAGE_ID | NUMBER | |||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
LOGIN_ID | NUMBER | |||
NODE_ID | NUMBER | |||
MAC_KEY | RAW | (20) | ||
ENC_KEY | RAW | (32) | ||
XSID | VARCHAR2 | (32) | ||
TIME_OUT | NUMBER | |||
GUEST | VARCHAR2 | (30) | ||
DISTRIBUTED | VARCHAR2 | (30) | ||
PROXY_USER_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, WINDOW_ID
, USER_ID
, MODE_CODE
, HOME_URL
, RESPONSIBILITY_APPLICATION_ID
, RESPONSIBILITY_ID
, SECURITY_GROUP_ID
, ORG_ID
, MENU_ID
, FUNCTION_ID
, FUNCTION_TYPE
, NLS_LANGUAGE
, LANGUAGE_CODE
, DATE_FORMAT_MASK
, COUNTER
, FIRST_CONNECT
, LAST_CONNECT
, NLS_DATE_LANGUAGE
, NLS_NUMERIC_CHARACTERS
, NLS_SORT
, NLS_TERRITORY
, LIMIT_TIME
, LIMIT_CONNECTS
, DISABLED_FLAG
, PSEUDO_FLAG
, PAGE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LOGIN_ID
, NODE_ID
, MAC_KEY
, ENC_KEY
, XSID
, TIME_OUT
, GUEST
, DISTRIBUTED
, PROXY_USER_ID
FROM ICX.ICX_SESSIONS#;
|
|
|