Re: Source of a view ...

From: Chris Kasten <kasten_at_pobox.com>
Date: Sat, 13 Jan 2001 20:17:50 -0700
Message-ID: <ig626tsfnq7rhgm5r7ck0m01otuqsrkm7a@4ax.com>

"Pavel Skalicky" <P.Skalicky_at_sh.cvut.cz> allegedly wrote:

> 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.
> Thanks
> Pavel

Try typing something like:

Set long 3000

before your query. Received on Sat Jan 13 2001 - 21:17:50 CST