from Which System View , I can retrieve the syntax of create view object .
1. www.dbasupport.com 2. www.dbforums.com 3. www.itpub.net 4. www.csdn.net 5. www.umlchina.com 6. www.tek-tips.com 7. www.cnforyou.com 8. fm365.federal.com.cn 9. www.programmersheaven.com 10.http://msdn.microsoft.com/library/default.asp ligang1000@hotmail.com
dba_views?
the column text of DBA_VIEWS in oracle7.3 is Long Type ?
what does desc dba_views say?
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
set long 5000 select text from dba_views where view_name = :your_view;
Forum Rules