[Home] [Help] [Dependency Information]
Object Name: | V_$SQL_REDIRECTION |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS | RAW | (8) | ||
PARENT_HANDLE | RAW | (8) | ||
HASH_VALUE | NUMBER | |||
SQL_ID | VARCHAR2 | (13) | ||
CHILD_NUMBER | NUMBER | |||
PARSING_USER_ID | NUMBER | |||
PARSING_SCHEMA_ID | NUMBER | |||
COMMAND_TYPE | NUMBER | |||
REASON | VARCHAR2 | (14) | ||
ERROR_CODE | NUMBER | |||
POSITION | NUMBER | |||
SQL_TEXT_PIECE | VARCHAR2 | (1000) | ||
ERROR_MESSAGE | VARCHAR2 | (1000) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS
, PARENT_HANDLE
, HASH_VALUE
, SQL_ID
, CHILD_NUMBER
, PARSING_USER_ID
, PARSING_SCHEMA_ID
, COMMAND_TYPE
, REASON
, ERROR_CODE
, POSITION
, SQL_TEXT_PIECE
, ERROR_MESSAGE
, CON_ID
FROM SYS.V_$SQL_REDIRECTION;
|
|
|