niimrod wrote:
> Does anyone know a query I can run against the DBA_xxx views to get
> the names of the columns in
> a view? For tables exist SYS.ALL_TAB_COLUMN, but thers's nothing ike
> thsi for views.
> Normally I would use "desc" but I'm working with thin-jdbc where desc
> doesn't work.
>
> Thanks.
>
> niimrod
Sadly xxx_tab_columns also contains views just as xxx_tab_privs includes
object privileges for all object types. The desire for backward
compatibility sometimes induces fascinating compromises.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Nov 28 2007 - 16:14:05 CST
