Neoview SQL Reference Manual (R2.2)

Other Functions and Expressions
Use these other functions and expressions in an SQL value expression:
A conditional expression. The two forms of the CASE
expression are simple and searched.
“CASE (Conditional) Expression” (page 295)
Converts a value from one data type to another data type
that you specify.
“CAST Expression” (page 298)
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 303)
Returns the role you logged in as.“CURRENT_ROLE Function” (page 314)
Returns the user name you logged in as.“CURRENT_USER Function” (page 317)
Compares expr to each test_expr value one by one in
the order provided.
“DECODE Function” (page 330)
Generates a result table describing an access plan for a
SELECT, INSERT, DELETE, UPDATE, or CALL statement.
“EXPLAIN Function” (page 339)
Returns the first argument if it is not null, otherwise it
returns the second argument.
“ISNULL Function” (page 346)
Returns the value of the first operand if the two operands
are not equal, otherwise it returns NULL.
“NULLIF Function” (page 377)
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 379)
Returns the user name you logged in as.“USER Function” (page 429)
See the individual entry for the function.
Categories 285