Re: Source of a view ...

From: Stephan Born <stephan.born_at_beusen.de>
Date: Mon, 15 Jan 2001 09:06:31 +0100
Message-ID: <3A62AF87.4E8D2819@beusen.de>

> Hallo,
> I have a problem, I need to check view, but I can't extract the source from
> database.
> I wrote
>
> select text from all_views where name = '..';
>
> but the text (source) isn't complete - it's only the beginning (select p1,
> p2, p3).
>
> select text from all_source ...
>
> has no result (there isn't a source of this view).
>
> Please help. Version of Oracle server is 64-bit 7.3.2.1.0 for Alpha.

the type of the TEXT-column is LONG. You have to type the following command
on sql*plus:

set long x

(with x representing the amount of characters which shall be displayed...)

so, set long 20000

works for me fine Received on Mon Jan 15 2001 - 02:06:31 CST