XML Feeds
Ideally, this type of high-level code review scan of our custom code could occur Quarterly and only look back at code created within the last Quarter for our Development environment. This gives a good pulse of how we are applying our best practices more »
PermalinkFull Table Scans are Evil
... there are nearly 300,000 records in the MASTER_TBL, but the execution plan indicates a cardinality of merely 3. So, there is something?s serious wrong somewhere. First suspect is table and index statistics. As suspected, statistics on MASTER_TBL were botched up... more »
PLSQL FTP Update :: Server Code and TCP Banners
Author Comments : Important issue identified regarding the structure of your remote FTP servers banners. Although with a true FTP client tool it may not be required, this FTP process follows best practice and expects that the server codes precede each line being returned by the remote FTP Server as it authenticates to the remote server. Failure to include the required prefix could cause you to be unable to access the remote server or failure to authenticate. more »
Prime example showing benefits of Analytical Functions
On the topic of analytical functions, I will be the first to say that they are not my strength. However that said, reading one article after another I am increasingly aware of what I am missing. I stumbled upon an excellent article demonstrating significant performance gains across the board from timing to resource utilization, all due to the use of analytical functions. I encourage you take some time and review the posting. more »
Count number of character occurences in a string
A question was posed on the listserver regarding the 'how' of identifying how many vowels are in a particular string of text. Not certain as to the purpose of same, however intresting nonetheless. For those on 10g+, use of the REGEXP% syntax comes into play. more »
:: Next >>