Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

Oracle - Expressions

This article describes identifiers in Oracle 11g and earlier.

Overview

Expression Description
DECODE() Compares expressions to each search value and returns the corresponding result.

DECODE

Oracle - DECODE
Syntax DECODE(expr, search, result {, search, result} [, default])
Parameter The arguments can be any of the numeric types (NUMBER, BINARY_FLOAT, or BINARY_DOUBLE) or character types.
Description Oracle compares expr to each search value one by one. If expr is equal to a search, Oracle returns the corresponding result.
If no match is found, Oracle returns default, or, if default is omitted, returns null.
The search, result, and default values can be derived from expressions.
Return Type If expr is equal to a search, returns result. If no match is found, returns default, or, if default is omitted, returns null.

Equivalents in Other Databases

Database Equivalent
MSSQL Server Simple CASE expression


Ispirer Home Page Ispirer SQLWays Product Page - Migration to Oracle Request SQLWays

sqlways/oracle/expressions.txt · Last modified: May 07, 2018, 03:15:28 PM (external edit)
 
© 1999-2018, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement