Dynamic Performance (V$) Views, 206 of 238

V$SQLTEXT_WITH_NEWLINES

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
`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"