Neoview SQL Reference Manual (R2.5)

Returns the number of rows counted since the specified
set of values last changed.
“ROWS SINCE CHANGED Function” (page 453)
Used in ROWS SINCE to distinguish between the value
of the column in the current row and the value of the
column in previous rows.
“THIS Function” (page 476)
See “SEQUENCE BY Clause” (page 326) and the individual entry for each function.
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 353)
A conditional expression. The two forms of the CASE
expression are simple and searched.
“CASE (Conditional) Expression” (page 354)
Converts a value from one data type to another data type
that you specify.
“CAST Expression” (page 357)
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 362)
Converts the specified value expression to hexadecimal
for display purposes.
“CONVERTTOHEX Function” (page 366)
Returns the role you logged in as.“CURRENT_ROLE Function” (page 375)
Returns the user name you logged in as.“CURRENT_USER Function” (page 378)
Compares expr to each test_expr value one by one in
the order provided.
“DECODE Function” (page 392)
Generates a result table describing an access plan for a
SELECT, INSERT, DELETE, UPDATE, or CALL statement.
“EXPLAIN Function” (page 401)
Returns the first argument if it is not null, otherwise it
returns the second argument.
“ISNULL Function” (page 408)
Returns the value of the first operand if the two operands
are not equal, otherwise it returns NULL.
“NULLIF Function” (page 434)
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 436)
Returns the user name you logged in as.“USER Function” (page 484)
See the individual entry for the function.
Categories 343