ombion.blogg.se

result1: The results are the values that will be returned if one of the search expressions matches the select expression.If more than one search expression would match, only the first match's result is returned. If one of these search expressions matches, the function returns the corresponding result. search1: The search expressions indicate the values to compare to the select expression.The select expression is typically a column, but can be a subquery, literal, or other expression. The "search expressions" are compared to this select expression, and if there is a match then DECODE returns the result that corresponds to that search expression. expr: This is the "select expression".As soon as a search expression matches the selection expression, the corresponding result expression is returned. expr1: Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL.ĭECODE(expr, search1, result1 )Ĭompares the select expression to each search expression in order.Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL. In accordance with Boolean semantics: Non-zero values (including negative numbers) are regarded as True. one of the expressions, but not both expressions, is TRUE). Zero values are regarded as False.Ĭomputes the Boolean XOR of two numeric expressions (i.e. Zero values are regarded as False.Ĭomputes the Boolean OR of two numeric expressions. Zero values are regarded as False.Ĭomputes the Boolean NOT of a single numeric expression. Non-zero values (including negative numbers) are regarded as True. Shift the bits for a numeric expression n positions to the right, with sign extension.īitwise XOR of two numeric expressions (a and b).Ĭomputes the Boolean AND of two numeric expressions. Shift the bits for a numeric expression n positions to the left.

expr: This expression must evaluate to a data type that can be cast to INTEGER.īitwise OR of two numeric expressions (a and b).expr2: This expression must evaluate to a data type that can be cast to INTEGER.īitwise negation of a numeric expression.expr1: This expression must evaluate to a data type that can be cast to INTEGER.Bitwise AND of two numeric expressions (a and b).