Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Retrieving all the view_text from all_views

Re: Retrieving all the view_text from all_views

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/11/20
Message-ID: <650m0r$kov@bgtnsc03.worldnet.att.net>#1/1

In SQL*Plus:

SET LONG 2000 (or any value you want; default is LONG=80)

Hope this helps.

Michael Serbanescu



On Wed, 19 Nov 1997 17:27:39 -0600, Matthew Burnett <others_at_zzapp.org> wrote:

>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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US