Re: Solved! I think (Re: select distinct on computed column)

In article <32D40E97.18AE_at_c-square.no.junk>, Alvin Sylvain <alvin_at_csquare. no.junk> writes
>
>P.S. I still don't know how to view the contents of a view.
>"select text from user_views where view_name = 'VIEW_NAME'"
>stops after about 100 or so characters. The only reason
>I had any clue to this view was the fact that I still have
>the old Sybase version.

The default display length in SQL*Plus for LONG fields is fairly short. You can change it as follows.

set long 4000

You may also have to -

set arraysize 1
set maxdata ???????

The product of arraysize and record size (sum of selected column lengths) must less than maxdata. Depending on your platform the maximum for arraysize may be as low as 32k (Windows/DOS) or 64k.

-- 
Jim Smith