Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieving all the view_text from all_views
In SQL*Plus:
SET LONG 2000 (or any value you want; default is LONG=80)
Hope this helps.
Michael Serbanescu
>Hi-
>
>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
Received on Thu Nov 20 1997 - 00:00:00 CST
![]() |
![]() |