Re: How to get the text of a view ?

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 03 Dec 1998 22:24:17 GMT
Message-ID: <36690e47.28725434@inet16.us.oracle.com>

On Thu, 03 Dec 1998 21:27:12 GMT, emmguyot_at_altavista.net wrote:

>
>
>In order to modifiy a view, I need to get back to text that was used to create
>the view. With it, I could modify the view.
>
>I found a table, something like dba_views, but I can't see the whole text.

You need to set long to a big number so all the text in that column is displayed.

try:

SQL> set long 1000000

SQL> select text from all_views where view_name = 'MY_VIEW'   2 and owner = 'CHRIS';

hope this helps.

chris.

>
>Thanks for you help
>
>-----------------------------------------------------------------------
>--------------------->>>> Emmanuel Guyot <<<<--------------------------
>8 Rue des Montées | Phone : [33] (0)2 38 56 42 72
>45100 Orléans | Email : emmguyot_at_altavista.net
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

--
Chirstopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Dec 03 1998 - 16:24:17 CST