Neoview SQL Reference Manual (R2.3)

Other Functions and Expressions
Use these other functions and expressions in an SQL value expression:
Performs 'and' operation on corresponding bits of the two
operands.
“BITAND Function” (page 304)
A conditional expression. The two forms of the CASE
expression are simple and searched.
“CASE (Conditional) Expression” (page 306)
Converts a value from one data type to another data type
that you specify.
“CAST Expression” (page 309)
Returns the value of the first expression in the list that
does not have a NULL value or if all the expressions have
NULL values, the function returns a NULL value.
“COALESCE Function” (page 314)
Returns the role you logged in as.“CURRENT_ROLE Function” (page 325)
Returns the user name you logged in as.“CURRENT_USER Function” (page 328)
Compares expr to each test_expr value one by one in
the order provided.
“DECODE Function” (page 341)
Generates a result table describing an access plan for a
SELECT, INSERT, DELETE, UPDATE, or CALL statement.
“EXPLAIN Function” (page 350)
Returns the first argument if it is not null, otherwise it
returns the second argument.
“ISNULL Function” (page 357)
Returns the value of the first operand if the two operands
are not equal, otherwise it returns NULL.
“NULLIF Function” (page 388)
Returns the value of the first operand unless it is NULL,
in which case it returns the value of the second operand.
“NVL Function” (page 390)
Returns the user name you logged in as.“USER Function” (page 440)
See the individual entry for the function.
Categories 295