Try "set long 5000" in sqlplus before running the query. -joe http://www.peaceaday.com ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu Sent: Friday, September 08, 2006 9:42 AM To: Oracle-L@Freelists. Org (E-mail) Subject: How does one get the definition of a view? How do I get the definition of a view?