Oracle 5.0, Reference Manual

Page: 885 / 3232

Function and Operator Reference
865
Name Description
BENCHMARK()
[957] Repeatedly execute an expression
BETWEEN ... AND ...
[877] Check whether a value is within a range of values
BIN()
[886] Return a string containing binary representation of a number
BINARY
[948] Cast a string to a binary string
BIT_AND()
[969] Return bitwise and
BIT_COUNT()
[952] Return the number of bits that are set
BIT_LENGTH()
[886] Return length of argument in bits
BIT_OR()
[969] Return bitwise or
BIT_XOR()
[969] Return bitwise xor
&
[951] Bitwise AND
~
[951] Invert bits
|
[951] Bitwise OR
^
[951] Bitwise XOR
CASE
[883] Case operator
CAST()
[948] Cast a value as a certain type
CEIL()
[909] Return the smallest integer value not less than the argument
CEILING()
[909] Return the smallest integer value not less than the argument
CHAR_LENGTH()
[887] Return number of characters in argument
CHAR()
[886] Return the character for each integer passed
CHARACTER_LENGTH()
[887] A synonym for CHAR_LENGTH()
CHARSET()
[958] Return the character set of the argument
COALESCE()
[878] Return the first non-NULL argument
COERCIBILITY()
[958] Return the collation coercibility value of the string argument
COLLATION()
[959] Return the collation of the string argument
COMPRESS()
[954] Return result as a binary string
CONCAT_WS()
[888] Return concatenate with separator
CONCAT()
[887] Return concatenated string
CONNECTION_ID()
[959] Return the connection ID (thread ID) for the connection
CONV()
[909] Convert numbers between different number bases
CONVERT_TZ()
[918] Convert from one timezone to another
CONVERT()
[948] Cast a value as a certain type
COS()
[909] Return the cosine
COT()
[909] Return the cotangent
COUNT(DISTINCT)
[970] Return the count of a number of different values
COUNT()
[970] Return a count of the number of rows returned
CRC32()
[909] Compute a cyclic redundancy check value
CURDATE()
[918] Return the current date
CURRENT_DATE()
,
CURRENT_DATE
[918]
Synonyms for CURDATE()
CURRENT_TIME()
,
CURRENT_TIME
[918]
Synonyms for CURTIME()