The Power of DECODE() - Doug Burns' Oracle and ZX Spectrum ...

The first thing to note is that the DECODE() function is defined in the Expr section of the Oracle SQL Language Reference Manual. This offers our first hint of the power of DECODE, because it indicates that we can use this function wherever we might use any other expression, in the SELECT, WHERE or ORDER BY clauses for example. So, here is the formal definition. DECODE(expr, search1, result1 ... ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download