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: Jomarlen <jomarlen_at_aol.com>
Date: 1997/11/23
Message-ID: <19971123020301.VAA00669@ladder02.news.aol.com>#1/1 







>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

>

>



The TEXT column is a LONG and is being truncated



SQL> SET LONG 50000


John
Received on Sun Nov 23 1997 - 00:00:00 CST












Original text of this message













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