>When you "DESCRIBE My_Oracle_View" in SQL*Plus, where is Oracle getting the structure information for that view? Specifically, I want to retrieve the view structure [columns, data types, data_length, etc] the same way you would for a table from the USER_TAB_COLUMNS view.
>
>The "Text" column from the User_Views view is NOT what I am after either.
>
>TIA!

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.