Select the full Text of an SQL Statement
Posted on 2011-03-07
I have an oracle 11 database. I was wondering if there is some way to select the complete text of sql statements from the v$sql... tables. i have tried looking at sql, sqltext, sqlarea, sql_plan, and sqltext_with_newlines, but the most the tables contain(by themselves) is 1000 characters of an sql statement. I would like to be able to type:
Select sql_text from something...and get the complete text of all sql statements in my database no matter how long it is. Is there a way to do this?