Larry Steinle

August 31, 2013

The Odd Relationship Between Null and Empty String in Oracle PL/SQL

Filed under: Oracle — Larry Steinle @ 10:18 am
Tags: ,

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…)

Advertisements

August 23, 2013

Programmatically Validating Oracle Packages

Filed under: Oracle — Larry Steinle @ 10:06 pm
Tags: , ,

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.

(more…)

August 18, 2013

JavaScript Chaining Made Fun!

Filed under: Web — Larry Steinle @ 6:59 pm
Tags: , , , ,

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.

(more…)

August 17, 2013

How to Create a Clean, Extensible JavaScript Library

Filed under: Web — Larry Steinle @ 10:21 pm
Tags: , , , , ,

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.

(more…)

Blog at WordPress.com.