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

**ligang** · 09-11-2002, 10:56 PM

**pando** · 09-12-2002, 02:16 AM

dba_views?

**ligang** · 09-12-2002, 02:22 AM

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

**pando** · 09-12-2002, 03:22 AM

what does desc dba_views say?

**SANJAY_G** · 09-12-2002, 04:31 AM

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

**ligang** · 09-17-2002, 10:16 PM

But the column can not be displayed properly in SQLPLUS .

**SANJAY_G** · 09-17-2002, 10:28 PM

Code:

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

HTH
Sanjay

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