Use DECODE for IF/ELSE Selection
Programmers often need a way to count and/or add up variable conditions for a group of rows. The DECODE statement provides a very efficient way of doing this. Because DECODE is rather complex, few programmers take the time to learn to use this statement to full advantage. The following statement uses DECODE to count the [...]
Written by admin on January 27th, 2011 with comments disabled.
Read more articles on Oracle Tuning.