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: How to get whole text from DBA_VIEWS?

Re: How to get whole text from DBA_VIEWS?

From: NoName <nobody_at_nowhere.com>
Date: Fri, 19 Dec 2003 17:20:10 +0100
Message-ID: <brv7fu$sgj$1@grillo.cs.interbusiness.it> 





> In SqlPLus:

>

> set LONG 1000

> select text from DBA_VIEWS where owner='myowner' and view_name='myview';




Ahh, I was missing the SET LONG command!!
So, since the DBA_VIEWS has a column with the text length, using SET LONG
with the value in that column...



Well, thank you, and happy Xmas holydays, to you and everybody here in this
newsgroup!



Best Regards
Received on Fri Dec 19 2003 - 10:20:10 CST












Original text of this message













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