SQL Standards dictate a very unique behavior for null values. You would think these behaviors would be consistent across databases. This article is for you Microsoft SQL developers who’ve been tossed into the Oracle world and are confused by the appalling violation of null behavior.
(more…)
August 31, 2013
The Odd Relationship Between Null and Empty String in Oracle PL/SQL
August 23, 2013
Programmatically Validating Oracle Packages
Whenever an Oracle view, function, procedure or package header is modified the object is invalidated and any objects that call the invalidated object become invalid. To avoid errors these objects need to be compiled. The purpose of this article is to demonstrate how to identify the invalid objects compiling them in the correct order so that all objects can be validated in one pass while providing the ability to track which objects fail to validate.
August 18, 2013
JavaScript Chaining Made Fun!
The chain pattern allows several actions to be executed within a single line of concurrent code. jQuery’s use of chaining has popularized the concept so that the masses now prefer chaining their method calls. Creating an application that supports chaining can be cumbersome. This article will demonstrate how to add chaining functionality to any JavaScript class without modifying any code in the class you want to upgrade to support the chaining pattern.
August 17, 2013
How to Create a Clean, Extensible JavaScript Library
One of the biggest challenges developer’s face when working with JavaScript is organizing their code into easy to manage, maintainable blocks of code. This article will step through the process to create a clean, simple, extensible JavaScript Library Framework.