ILT – Divide and Conquer Strategy – Why it is so powerful

08/02/2013 Divide and Conquer is a very interesting and effective strategy that has been used by many technical experts, leaders, mangers, and warriors through out the world for many years. Following is a story of the famous Sri Lankan king Dutugemunu. Apparently he learnt the lesson from an old woman! King Dutugemunu was fighting hisContinue reading “ILT – Divide and Conquer Strategy – Why it is so powerful”

Replace Function Doesn’t Replace Double Quotation in VBA

13-11-2012 I had to remove all double quotation marks from a string using VBA. I tried to do this by using the Replace function as shown below. Also Note that two double quotation marks are used to represent the quotation mark. This is because the quotation mark is a special character in VBA and weContinue reading “Replace Function Doesn’t Replace Double Quotation in VBA”

Oracle Trunc Function

2008-11-24 Among various helpful functions provided by Oracle, Trunc function took my attention today because I had to fix a defect where some one has misunderstood and misused this function. As the name itself suggests, the trunc function is capable of truncating a value. This function can be used either on a date type valueContinue reading “Oracle Trunc Function”