You might want to increase the value of sqlplus' variable long. set long 8000 then select text from dba_views where .... On Tue, Feb 17, 2009 at 12:17 PM, VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>wrote: > Folks > > > > Wherefrom can the source code definition of a View be obtained? > > > > If sys.dba_views, it's Field "TEXT" is a LONG datatype. How can it's > contents be read? > > > > Cheers & Thanks V much > > > > > > SQL> desc sys.dba_views > > Name Null? Type > > ----------------------------------------- -------- > ---------------------------- > > OWNER NOT NULL VARCHAR2(30) > > VIEW_NAME NOT NULL VARCHAR2(30) > > TEXT_LENGTH NUMBER > > TEXT LONG > > TYPE_TEXT_LENGTH NUMBER > > TYPE_TEXT VARCHAR2(4000) > > OID_TEXT_LENGTH NUMBER > > OID_TEXT VARCHAR2(4000) > > VIEW_TYPE_OWNER VARCHAR2(30) > > VIEW_TYPE VARCHAR2(30) > > SUPERVIEW_NAME VARCHAR2(30) > > > > > > > > **************** CAUTION - Disclaimer ***************** > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely > for the use of the addressee(s). If you are not the intended recipient, please > notify the sender by e-mail and delete the original message. Further, you are > not > to copy, disclose, or distribute this e-mail or its contents to any other > person and > any such actions are unlawful. This e-mail may contain viruses. Infosys has > taken > every reasonable precaution to minimize this risk, but is not liable for any > damage > you may sustain as a result of any virus in this e-mail. You should carry out > your > own virus checks before opening the e-mail or attachment. Infosys reserves the > right to monitor and review the content of all messages sent to or from this > e-mail > address. Messages sent to or from this e-mail address may be stored on the > Infosys e-mail system. > ***INFOSYS******** End of Disclaimer ********INFOSYS*** > > -- Toon Koppelaars RuleGen BV +31-615907269 Toon.Koppelaars@xxxxxxxxxxx www.RuleGen.com (co)Author: "Applied Mathematics for Database Professionals"