Re: How to determine query that created view?

clark murray wrote:
>
> Given a view is it possible to find out the query that created it.

By query I gather you actually mean the Data Definition Language (DDL) that created it. The answer is yes. Look at SYS.VIEW$, if you can (you must be granted access to it). The DDL is in the field called "TEXT". However, it is stored as a LONG. If using SQL*Plus, set the LONG option (which controls how many bytes of LONG type fields are displayed) to display more than the default 80 characters allotted.

-- 
Hugo Toledo, Jr.   Author of "Oracle Networking" from Oracle Press
312.951.8012               Oracle WebSystem - Oracle Mobile Agents
mailto:hugo_at_mcs.com      Oracle Power Objects - Windows - Unix - C
http://www.mcs.com/~hugo/oracle.html        CompuServe: 72700,1705