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

From: Channa, Santhosh <>
Date: Tue, 17 Feb 2009 09:03:59 -0600
Message-ID: <>

Or you can spool them into a file using utl_file package.  

Santhosh Channa
P Consider the environment. Please don't print this e-mail unless you really need to.

From: Toon Koppelaars [] Sent: Tuesday, February 17, 2009 6:34 AM To:
Subject: Re: View's Source Code ? ... Basic Qs  

You might want to increase the value of sqlplus' variable long.

set long 8000


select text from dba_views where ....

On Tue, Feb 17, 2009 at 12:17 PM, VIVEK_SHARMA < <> > wrote:


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 <> 

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

Received on Tue Feb 17 2009 - 09:03:59 CST

Original text of this message