AD

oracle COALESCE function resolution

COALESCE
Returns its argument in the first non-empty expression.

Grammar
COALESCE (expression [, ... n])

Parameter
expression

Any type of expression.

n

You can specify multiple expressions that placeholder. All expressions must be the same type, or can be implicitly converted to the same type.

Return type will return the same value as expression.

Note If all arguments are NULL, COALESCE returns NULL.

COALESCE (expression1, ... n) is equivalent to this CASE function:

CASE
WHEN (expression1 IS NOT NULL) THEN expression1
...
WHEN (expressionN IS NOT NULL) THEN expressionN
ELSE NULL
标签: oracle, expressions, parameter expression, expression grammar
分类: Database
时间: 2010-11-08

相关文章

  1. oracle (COALESCE function)

    Database application software will often multiple, related entities, the information stored in the same table. ...
  2. oracle COALESCE function analysis

    COALESCE Return to their argument the first non-empty expression. Syntax COALESCE (expression [, ... n]) Param ...
  3. oracle's NVL, NVL2, NULLIF, COALESCE function of several common

    Oracle introduced in the previous string handling functions, date functions, mathematical functions, and the t ...
  4. ORACLE common function Demo

    ORACLE common function Demo Documents written: Meng New EDITORIAL: ORACLE built-in function, the equivalent of ...
  5. NVL, NVL2, NULLIF, COALESCE function

    1.NVL function NVL function format is as follows: NVL (expr1, expr2) If the oracle first argument is empty the ...
  6. Oracle SYS_CONTEXT Function

    Oracle SYS_CONTEXT Function Version 11.2 Oracle SYS_CONTEXT Function Version 11.2 Actions As SYS Note: USERENV ...
  7. oracle date function switch

    oracle date functions Oracle date function Collection (1) A commonly used data format date 1.Y or YY or YYY la ...
  8. Oracle plsql function Daquan

    Oracle plsql function Daquan SQL in single-record function 1.ASCII Returns the character corresponding to the ...
  9. Oracle Database Function (single function)

    Oracle Database Function (single function) Oracle's functions and C functions in almost the same also have the ...
  10. oracle substr function in the usage of

    oracle substr function in the usage of In oracle / PLSQL, the substr functions allows you to extract a substri ...
  11. Oracle analytic function RANK (), ROW_NUMBER (), LAG () to use such

    Oracle analytic function RANK (), ROW_NUMBER (), LAG () to use such ROW_NUMBER () OVER (PARTITION BY COL1 ORDE ...
  12. oracle Round () function

    oracle Round () function Round () function Return a value, the decimal value according to a specified number o ...
  13. Oracle built-in function (greatest, least, to_single_byte)

    Oracle built-in function (greatest, least, to_single_byte) Take a maximum of one-dimensional array greatest SE ...
  14. sqlserver coalesce function

    SQL Server COALESCE () function COALESCE function returns the list of features the first non-empty expression. ...
  15. Oracle date function and application (transfer)

    Oracle date function and application (transfer) I believe many people have had the experience of some of the d ...
  16. Oracle analytic function RANK (), ROW_NUMBER (), LAG () and so the use of methods (Reprinted)

    Oracle analytic function RANK (), ROW_NUMBER (), LAG () to use such ROW_NUMBER () OVER (PARTITION BY COL1 ORDE ...
  17. sql coalesce () function application

    Quote COALESCE () function --- Introduction --- T-SQL's COALESCE () function lets you specify multiple express ...
  18. Oracle Single Function

    - Upper ------- convert characters to uppercase SELECT Upper ('abcde') FROM dual; - Lower ----- convert charac ...
  19. oracle instr function

    oracle instr function For an instr function, so we often use: to find the specified string from a substring po ...