From: mcstockX@Xenquery   
      
   "UNIXNewBie"  wrote in message   
   news:dpCdncJpPuzV59XdRVn-ug@magma.ca...   
   | want to determine the select statement for a view.   
   |   
   | I have found a view called ALL_VIEWS which looks promising for this   
   purpose.   
   | The view contains a column called TEXT which appears to have the   
   information   
   | I am looking for. However, when I perform the following select I cannot   
   see   
   | all of the field TEXT. It's truncated for some reason. I have used SET   
   | LINESIZE to 32000 to no avail!   
   |   
   | two questions   
   |   
   | 1) why is this field truncated?   
   |   
   | 2) how do I determine the select statement for a view without using the   
   | management GUIs?   
   |   
   | Thanks   
   |   
   | J.   
   |   
   |   
      
   presumably you're using sql*plus   
      
   the TEXT column is datatype LONG   
      
   by default sql*plus only displays the first 80 characters of a LONGS   
      
   issue 'SET LONG nn'  to see more (ie, nn) characters   
      
   -{ mcs   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)