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

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.

Column USER_VIEWS.TEXT is of type LONG. If you are using Sql*Plus set the LONG environment variable to larger value. The default is 80, so LONG columns are truncated after 80 characters.

You can determine the appropriate number by looking at USER_VIEWS.TEXT_LENGTH and then in Sql*Plus use

        SET LONG <needed_length>

If the length is high, you will probably also have to set ARRAYSIZE to appropriate value.

Jure

-- 
 ===============================================================
 ! Jurij Modic                            Republic of Slovenia !
 !  tel: +386 61 178 55 14                Ministry of Finance  !
 !  fax: +386 61  21 45 84                Zupanciceva 3        !
 !  e-mail: jurij.modic_at_mf.sigov.mail.si  Ljubljana 1000       !
 ===============================================================