Re: Retrieving all the view_text from all_views

>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?
>
>Thanks,
>Matthew Burnett
>

view_text is a long. The default in SQLPLUS for display of a long is 200 characters. Before you do the query, enter the SQLPLUS command

SET LONG 2000 This will display up to2000 characters of a long. If your views are longer, set a bigger number.

Dan Received on Sat Nov 22 1997 - 00:00:00 CST