Dynamic Performance (V$) Views, 158 of 179

Oracle8i Reference
Release 2 (8.1.6)
Part Number A76961-01

Dynamic Performance (V$) Views, 158 of 179

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.

See Also:
"V$SQLTEXT".

Column Datatype Description

ADDRESS

RAW

Used with HASH_VALUE to identify uniquely a cached cursor

HASH_VALUE

NUMBER

Used with ADDRESS to identify uniquely a cached cursor

PIECE

NUMBER

Number used to order the pieces of SQL text

SQL_TEXT

VARCHAR2

A column containing one piece of the SQL text

COMMAND_TYPE

NUMBER

Code for the type of SQL statement (SELECT, INSERT, etc.)

Oracle

Copyright © 1996-2000, Oracle Corporation.
All Rights Reserved.