>Hi Mark,
>Working from the User_Views view, I got:

>select o.name view_name, c.name col_name, c.length, c.precision#
>   from sys_obj$ o, sys.col$ c
>   where o.obj# = c.obj#
>      and o.owner# = userenv('SCHEMAID')
>      and upper(o.name) like 'MYVIEWNAME%'
>   order by c.col#

>HTH.

Hi Larry,

That works perfectly. Just 1 typo though -- sys_obj$ should be sys.obj$

Thanks!