This view is identical to the V$SQLTEXT view except that, to improve legibility, V$SQLTEXT_WITH_NEWLINES does not replace newlines and tabs in the SQL statement with spaces.
| Column | Datatype | Description |
|---|---|---|
ADDRESS |
RAW(4 | 8) |
Used with HASH_VALUE to uniquely identify a cached cursor |
HASH_VALUE |
NUMBER |
Used with ADDRESS to uniquely identify a cached cursor |
SQL_ID |
VARCHAR2(13) |
SQL identifier of a cached cursor |
COMMAND_TYPE |
NUMBER |
Code for the type of SQL statement (SELECT, INSERT, and so on) |
PIECE |
NUMBER |
Number used to order the pieces of SQL text |
SQL_TEXT |
VARCHAR2(64) |
A column containing one piece of the SQL text |
See Also:
"V$SQLTEXT"