Re: Complete (more than 4000 char) text of fixed view definition?
From: Stephane Faroult <sfaroult_at_roughsea.com>
Date: Fri, 15 Apr 2011 20:00:05 +0200
Message-ID: <4DA887A5.5000607_at_roughsea.com>
cd $ORACLE_HOME/bin
strings oracle
Date: Fri, 15 Apr 2011 20:00:05 +0200
Message-ID: <4DA887A5.5000607_at_roughsea.com>
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
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 15 2011 - 13:00:05 CDT