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!
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao