Complete (more than 4000 char) text of fixed view definition?

  • From: Paresh Yadav <yparesh@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 15 Apr 2011 13:26:20 -0400

Hi,

How can I get complete (more than 4000 char) text of fixed view definition?

SQL> desc v$fixed_view_definition

Name                                      Null?    Type
 ----------------------------------------- -------- -----------------------

 VIEW_NAME                                          VARCHAR2(30)
 VIEW_DEFINITION                                    *VARCHAR2(4000)*

-- 
Thanks
Paresh

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 04-2011