set long 1000 or another number >= text_length _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu Sent: 08 September 2006 16:42 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? I used the following SQL but not getting all definition text - I know something needs to be done on the format of long type. 1 select TEXT_LENGTH,TEXT 2 from dba_views 3 where OWNER = 'TSDBA' 4* and VIEW_NAME = 'FL_EXPORT_DB_VIEW' SQL> / TEXT_LENGTH ----------- TEXT -------------------------------------------------------------------------------- 872 SELECT RS_SESSION.REGION_ID, RS_SESSION.SESSION_DATE, RS_ROUTE.ROUTE_ID AS ROUT SQL> Thanks, Roger Xu This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o ____________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ==============================================================================