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 »
PermalinkSIMPLE_INTEGER Datatype
Sourced from http://www.oracle-base.com/articles/11g/PlsqlNewFeaturesAndEnhancements_11gR1.php#simple_integer The SIMPLE_INTEGER datatype is a subtype of the PLS_INTEGER datatype and can dramatically increase the speed of integer ari… more »
11g is now on board...
Well we finally upgraded to 11g at work. New playground for me to play in. Few things that most are aware of already more »
Full 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 »
:: Next >>