Source of a view ...

From: Pavel Skalicky <P.Skalicky_at_sh.cvut.cz>
Date: Fri, 12 Jan 2001 16:06:00 +0100
Message-ID: <3a5f1d54@news.cvut.cz>

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

---

Pavel Skalický
e-mail - P.Skalicky_at_seznam.cz
www - http://pts.kvalitne.cz
mobil - 0604 844 698
ICQ - 38169741 Received on Fri Jan 12 2001 - 09:06:00 CST