RE: views on views on views

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <ganstadba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 26 Mar 2009 13:05:05 -0400

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:

 

"

 

Other related posts: