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

From: Channa, Santhosh <Santhosh.Channa_at_McKesson.com>
Date: Tue, 17 Feb 2009 09:03:59 -0600
Message-ID: <75064C4060A3A24787B52E1F7D3E410C09F6C96D_at_DBQV3005.na.corp.mckesson.com>

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

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

---

From: Toon Koppelaars [mailto:toon.koppelaars_at_rulegen.com] Sent: Tuesday, February 17, 2009 6:34 AM To: VIVEK_SHARMA_at_infosys.com
Cc: ORACLE-L
Subject: Re: View's Source Code ? ... Basic Qs  

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 <mailto: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 <http://www.RuleGen.com> 

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


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

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