Neoview SQL Reference Manual (R2.4)

Returns the number of rows counted since the specified
set of values last changed.
“ROWS SINCE CHANGED Function” (page 436)
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 459)
See “SEQUENCE BY Clause” (page 306) 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 333)
A conditional expression. The two forms of the CASE
expression are simple and searched.
“CASE (Conditional) Expression” (page 334)
Converts a value from one data type to another data type
that you specify.
“CAST Expression” (page 337)
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 342)
Converts the specified value expression to hexadecimal
for display purposes.
“CONVERTTOHEX Function” (page 345)
Returns the role you logged in as.“CURRENT_ROLE Function” (page 354)
Returns the user name you logged in as.“CURRENT_USER Function” (page 357)
Compares expr to each test_expr value one by one in
the order provided.
“DECODE Function” (page 371)
Generates a result table describing an access plan for a
SELECT, INSERT, DELETE, UPDATE, or CALL statement.
“EXPLAIN Function” (page 380)
Returns the first argument if it is not null, otherwise it
returns the second argument.
“ISNULL Function” (page 387)
Returns the value of the first operand if the two operands
are not equal, otherwise it returns NULL.
“NULLIF Function” (page 417)
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 419)
Returns the user name you logged in as.“USER Function” (page 474)
See the individual entry for the function.
Categories 323