I hate retyping < arrgghh >! I tested it on one machine and posted using another.

Glad it helped!

>>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!