Re: More Ammo Against Dynamic SQL?

True oh true... :)  I had fantastic developers that I worked with when I was at 
the Parenting Company, (eToys) and they could do amazing things with views as 
well as dynamic SQL, but they knew the pitfalls to avoid and the right 
combinations that worked.  
 
I think that's one of the big frustrations for both DBAs and Developers-  there 
are so many features out there, but the wrong combination or used in the wrong 
way, you can end up with a database designed on a very shaky foundation-  
something that often makes DBA's quite cranky.... :)


Kellyn Pedersen
Multi-Platform DBA
I-Behavior Inc.
http://www.linkedin.com/in/kellynpedersen
 
"Go away before I replace you with a very small and efficient shell script..."

--- On Mon, 11/30/09, Rumpi Gravenstein <rgravens@xxxxxxxxx> wrote:


From: Rumpi Gravenstein <rgravens@xxxxxxxxx>
Subject: Re: More Ammo Against Dynamic SQL?
To: "Kellyn Pedersen" <kjped1313@xxxxxxxxx>
Cc: "cary millsap" <cary.millsap@xxxxxxxxxxxx>, michael.fontana@xxxxxxxxxxx, 
mwf@xxxxxxxx, "oracle Freelists" <oracle-l@xxxxxxxxxxxxx>
Date: Monday, November 30, 2009, 1:02 PM


<snip>
VIEW" is a four letter word in my book and I find them more abused 
than...than...dynamic SQL
</snip>

In my view this falls into the power tool category.  Take the chainsaw, 
depending on the hands you can end up with either massacre or an ice 
sculpture.  There is much in the Oracle programming tool chest like that.

Rumpi Gravenstein



      

Other related posts: