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

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 15 Apr 2011 20:00:05 +0200

cd $ORACLE_HOME/bin
strings oracle

Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>

On 04/15/2011 07:26 PM, Paresh Yadav wrote:
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: