SQL Functions

DECODE

The DECODE function is similar to CASE. DECODE handles simple
IF - THEN - ELSE logic at a select-item level.

DECODE is an Oracle extension to the SQL2 standard that Omnidex supports. It is available through ODBC and JDBC.

To use the DECODE function in ODXSQL, append the SQL_SYNTAX=OMNIDEX_PLUS WITH option to the SQL statement.

Syntax

DECODE( condition-expression , scalar-expression [, scalar-expression])

or

DECODE( scalar-expression-1 , scalar-expression-2 , scalar-expression-3 [, scalar-expression-4 ] )

top

Example

top