On average -- the where exists will significantly outperform the count(*). So I like to think of it in terms of this, instead of using the trial and error method to determine which method is okay to use *this* time… instead get used to using a single method that you will behave consistently regardless of the situation. Code ends up being efficient, consistent, and it requires less of your development time in the end. more »
Application Architect responsibilities should include periodic high-level review of code
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 »
SIMPLE_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 »
Single Sign On (SSO) solution for Oracle Applications
If you are looking for a way to build your own Single Sign On to Oracle Self Service Environment, here is an idea that you might like to try (Note : This solution requires 10g RUP patch instance or greater) 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 »
:: Next >>


