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

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <Roger.Xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org \(E-mail\)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 Sep 2006 11:45:54 -0400

set long <some_big_number>
try:
set long 10000
 
 
 

-- 
Mark J. Bobak 
Senior Oracle Architect 
ProQuest Information & Learning 

"A human being should be able to change a diaper, plan an invasion,
butcher a hog, conn a ship, design a building, write a sonnet, balance
accounts, build a wall, set a bone, comfort the dying, take orders, give
orders, cooperate, act alone, solve equations, analyze a new problem,
pitch manure, program a computer, cook a tasty meal, fight efficiently,
die gallantly. Specialization is for insects."   --Robert A. Heinlein


 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Friday, September 08, 2006 11:42 AM
To: Oracle-L@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.

Other related posts: