Re: View's Source Code ? ... Basic Qs

From: Toon Koppelaars <toon.koppelaars_at_rulegen.com>
Date: Tue, 17 Feb 2009 12:34:11 +0100
Message-ID: <ecf3dae70902170334g7341a03aj81864d607fd8903d_at_mail.gmail.com>

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_at_infosys.com>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_at_RuleGen.com
www.RuleGen.com

(co)Author: "Applied Mathematics for Database Professionals"

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 17 2009 - 05:34:11 CST