DBA Data[Home] [Help]

VIEW: SYS.V_$SQLTEXT_WITH_NEWLINES

Source

View Text - Preformatted

select "ADDRESS","HASH_VALUE","SQL_ID","COMMAND_TYPE","PIECE","SQL_TEXT","CON_ID" from v$sqltext_with_newlines
View Text - HTML Formatted

SELECT "ADDRESS"
, "HASH_VALUE"
, "SQL_ID"
, "COMMAND_TYPE"
, "PIECE"
, "SQL_TEXT"
, "CON_ID"
FROM V$SQLTEXT_WITH_NEWLINES