Re: View's Source Code ? ... Basic Qs
- From: Toon Koppelaars <toon.koppelaars@xxxxxxxxxxx>
- To: VIVEK_SHARMA@xxxxxxxxxxx
- Date: Tue, 17 Feb 2009 12:34:11 +0100
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"
Other related posts:
