from Which System View , I can retrieve the syntax of create view object .
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

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

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    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

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dba_views?

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    the column text of DBA_VIEWS in oracle7.3 is Long Type ?
    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

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what does desc dba_views say?

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    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

  6. #6
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    But the column can not be displayed properly in SQLPLUS .
    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

  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Code:
    set long 5000
    select text from dba_views 
    where view_name = :your_view;
    HTH
    Sanjay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width