| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
V$SQLTEXT_WITH_NEWLINES 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_VALUEto uniquely identify a cached cursor | 
| HASH_VALUE | NUMBER | Used with ADDRESSto 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"