RE: Egregious coding

From: Wong, Bing <bing.wong_at_IngramMicro.com>
Date: Thu, 06 Sep 2001 15:54:28 -0700
Message-ID: <F001.00385FB4.20010906155551@fatcity.com>

<SPAN

class=892455522-06092001>I think it is best to escalate this to management to deal with bad SQL coding. May be your shop needs SQL coding standard?
<SPAN

class=892455522-06092001>
<SPAN

class=892455522-06092001>

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Hagedorn, Linda   [mailto:lindah_at_epocrates.com]Sent: Thursday, September 06, 2001   4:06 PMTo: Multiple recipients of list ORACLE-LSubject:   Egregious coding
  Has anyone thought of a clever way to fail every   SQL statement that does not use a bind variable that I could switch on and off   as required?
  I'm looking at hundreds of thousands of queries in   the v$sqlarea in production. I've taken engineering management to task   over this, and have gotten empty promises in return. I would love to   hold a valid threat over their heads that I'm going to shut off every   statement that is not coded properly.   Any ideas are appreciated.
  Linda

    Received on Thu Sep 06 2001 - 17:54:28 CDT