sum(decode(extract(year from hire_date),2005, 1, 0)) "2005", sum(decode(extract(year from hire_date),2006, 1, 0)) "2006", sum(decode(extract(year from hire_date),2007 ...
Oracle database prior to 8.1.6 only had DECODE function. CASE was introduced in Oracle 8.1.6 as a standard, more meaningful and more powerful function. Everything DECODE can do, CASE can. There is a ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results