DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: view text from all_views

  1. #1
    Join Date
    Sep 2000
    Posts
    17
    I am trying to get the script of view using all_views , text column. When I spool it in sqlplus, I am not able to get the
    full text in the file.

    Am I missing something.

    Also, as the text is a long column , I am not able to do a
    substr or any operation on that. I am sure there is a
    round about way to do this.

    Can somebody help me on this.

  2. #2

    longs...

    Im guessing its that you need to set the 'long' setting.
    In sqlplus, try

    set pagesize 1000
    set long 1000000

    try running the query again to get the text and let me know if that works. If not then I will have another think :-)

  3. #3
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    Hi bmycroft,

    I was just wondering the same thing as ganesh when I came across this thread.

    The solution you gave works a treat.

    Many thanks

    Allie.

  4. #4
    Join Date
    Sep 2000
    Posts
    17
    Hi Bmycroft,
    Ur suggestion worked great!
    Is there a way to manipulate the long column ?

    Many Thanks,
    Ganesh.

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