RE: How does one get the definition of a view?

From: Lawie, Duncan <duncan.lawie_at_credit-suisse.com>
Date: Fri, 8 Sep 2006 16:52:57 +0100
Message-ID: <07150B51CE30744CBBB58E696139708DFDDD1E@elon11p32002.csfp.co.uk>

set long 1000
or another number >= text_length

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu Sent: 08 September 2006 16:42
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: How does one get the definition of a view?

How do I get the definition of a view?  

I used the following SQL but not getting all definition text - I know something needs to be done on the format of long type.  

  1 select TEXT_LENGTH,TEXT
  2 from dba_views
  3 where OWNER = 'TSDBA'
  4* and VIEW_NAME = 'FL_EXPORT_DB_VIEW' SQL> /   TEXT_LENGTH

---

TEXT

---

        872
SELECT RS_SESSION.REGION_ID,
RS_SESSION.SESSION_DATE,
        RS_ROUTE.ROUTE_ID AS ROUT   SQL>   Thanks,

Roger Xu

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o

---

This email has been scanned for all viruses by the MessageLabs Email Security System.

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

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

Received on Fri Sep 08 2006 - 10:52:57 CDT