Re: Retrieving all the view_text from all_views

Matthew Burnett <others_at_zzapp.org> wrote in article <347375EB.BAA96B95_at_zzapp.org>...
> I'm trying to pull the view text out of the table 'all_views', and am
> getting much less text than I know is in there.
>
> Does anyone know how to pull all of the text out of that columns?

The SQL is:
SELECT text FROM all_views WHERE owner = '<owner>' AND view_name = '<name>'

If you're not seeing all the text on the client, you may have run into a limitation/bug/whatever on the client that causes it not to display Oracle LONG datatypes correctly.

regards,
Billy Received on Thu Nov 20 1997 - 00:00:00 CST