Getting the View code

I'm trying to get the source code for a view that I have set up in my database. When I try to select it get only the first line of the view:

select * from dba_views where view_name = 'CIL_CURRENT_VIEW'

Owner    View_name                        Text_length      Text
=====    =================     ==========    ====================
CIL        CIL_CURRENT_VIEW            4484            SELECT

I know that there is more to the TEXT column, but I can't remember what environment setting that controls the listing of the column (if that's the problem).

Can someone give me a hint?

Thanks in advance,
Greg Lechkun
lechkung<remove>@tir.com Received on Wed May 12 1999 - 15:55:25 CDT