V$SQLAREA view only displays the first 80 character of sql statement
V$SQLAREA view only displays the first 80 character of sql statement
From: "Teffany Harris " <oracledba-ezmlmshield-x324263.[Email Address Removed] Subject: V$SQLAREA view only displays the first 80 character of sql statement Date: Wed, 2 Jun 2004 09:50:32 -0400
Hi all, The V$SQLAREA view only displays the first eighty characters of the SQL_TEXT field is it possible to view the whole sql statement? If so what do I need to do?