i m using oracle 10g. How can i find the complete text of an sql statement?
V$SQLTEXT has this output..
SQL> desc v$sqltext
Name Null? Type
----------------------------------------------- -------- --------------------------------
ADDRESS RAW(8)
HASH_VALUE NUMBER
SQL_ID VARCHAR2(13)
COMMAND_TYPE NUMBER
PIECE NUMBER
SQL_TEXT VARCHAR2(64)
i have also checked out v$sql and v$sqlarea...both have sql_text field's length varchar2(1000)