Tony Patton offers .NET developers a few guidelines for developing efficient database code. For instance, he explains when to use the WHERE clause and reveals what code to avoid.
Using Oracle's COALESCE function as a quick CASE statement
In this Oracle tip, Bob Watkins explains how you can use the COALESCE function in lieu of the more wordy CASE statement when testing for null results in multiple expressions.
In this Oracle tip, Bob Watkins explains how you can use the COALESCE function in lieu of the more wordy CASE statement when testing for null results in multiple expressions.
No comments:
Post a Comment