Select the full Text of an SQL Statement

Hello,
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?  

Thank you
LVL 4
Alex MatzingerDatabase AdministratorAsked:
Who is Participating?
 
MrNedConnect With a Mentor Commented:
If you're using sqlplus, try:

set long 100000

0
 
MrNedCommented:
You will have to query the CLOB column in v$sqlstats.sql_fulltext
0
 
Alex MatzingerDatabase AdministratorAuthor Commented:
yes i have and the column returns even less text than the reg varchar2(1000) text fields.  It appears to be showing me maybe 64 chars.  Is there a way to expand how much it is showing me?  
0
 
Alex MatzingerDatabase AdministratorAuthor Commented:
Wow...thank you for the help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.