from Which System View , I can retrieve the syntax of create view object .

from Which System View , I can retrieve the syntax of create view object .

dba_views?

the column text of DBA_VIEWS in oracle7.3 is Long Type ?

what does desc dba_views say?

Quote:

---

the column text of DBA_VIEWS in oracle7.3 is Long Type ?

---

Yes. to avoid truncation of text.
set long 5000
or whatever value you need..

HTH
Sanjay

But the column can not be displayed properly in SQLPLUS .

Code:

---

set long 5000
select text from dba_views
where view_name = :your_view;

---

HTH
Sanjay