RE: views on views on views

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 26 Mar 2009 12:57:36 -0400
Message-ID: <BAY141-DAV10A67E163E193A8B7C76EEA6910_at_phx.gbl>
Message-ID: <F35E99C8C5F842D5AEA9C16C6C9418C9_at_vpmcm01>



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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Carol Dacko
Sent: Thursday, March 26, 2009 11:49 AM
To: chris_stephens_at_admworld.com
Cc: oracle-l_at_freelists.org
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.singingsql.com/newsletter07.htm  

The first paragraph hits the nail on the head:  

"  

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 26 2009 - 11:57:36 CDT

Original text of this message