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

If you are using SQL*Plus, try typing "set long 10000" and see if that's big enough to display the entire text of the view. The text field in user_views should be of datatype LONG (at least that's what it is in all_views), and the default setting of LONG (500, I think) isn't big enough to print out the entire field.

Alvin Sylvain wrote:

...

> 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.
  Received on Thu Jan 09 1997 - 00:00:00 CST