Sounds like time for someone to "lock & load" and go hunting, duhvelopers that is. Dick Goulet ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael McMullen Sent: Thursday, March 26, 2009 12:58 PM To: oracle-l@xxxxxxxxxxxxx Subject: RE: views on views on views I have one group that loves views but also loves the "with" statement. So it's views on top of views on top of "with" statements on top of "with" statements. ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Carol Dacko Sent: Thursday, March 26, 2009 11:49 AM To: chris_stephens@xxxxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: views on views on views Dear Chris, We feel your pain! It is pervasive in our environment. Security views I can understand, but views, on views, on views, is just a nightmare. Dan Tow just did a great talk at the HOTSOS Symposium, "Safe Use of Views? Just Say "No"? ". Dan Tow also has a featured article on his website called Views, From Forty-Thousand Feet. The link is here: http://www.singingsqlcom/newsletter07.htm <http://www.singingsql.com/newsletter07.htm> The first paragraph hits the nail on the head: "