RE: View's Source Code ? ... Basic Qs
- From: "Channa, Santhosh" <Santhosh.Channa@xxxxxxxxxxxx>
- To: toon.koppelaars@xxxxxxxxxxx, VIVEK_SHARMA@xxxxxxxxxxx
- Date: Tue, 17 Feb 2009 09:03:59 -0600
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@xxxxxxxxxxx]
Sent: Tuesday, February 17, 2009 6:34 AM
To: VIVEK_SHARMA@xxxxxxxxxxx
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@xxxxxxxxxxx <mailto: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 <http://www.RuleGen.com>
(co)Author: "Applied Mathematics for Database Professionals"
Other related posts:
