DBA Data[Home] [Help]

VIEW: SYS.GV_$SQLTEXT_WITH_NEWLINES

Source

View Text - Preformatted

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

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