I'm using select sql_text from v$sql to view the currently running query in my aplication. It shows only 4000 chars of running query. So that I used the following,
select sql_fulltext from v$sql
But it showing only as clob. How can I view the whole query in this case in oracle?
Best Answer
sqlplus has not problems showing CLOB contents, just make sure to ..
so some such high number > the max size of your CLOB, before running the query.