Oracle 5.0, Reference Manual

Page: 887 / 3232

Function and Operator Reference
867
Name Description
FROM_DAYS()
[923] Convert a day number to a date
FROM_UNIXTIME()
[923] Format UNIX timestamp as a date
GET_FORMAT()
[924] Return a date format string
GET_LOCK()
[965] Get a named lock
>=
[876] Greater than or equal operator
>
[876] Greater than operator
GREATEST()
[878] Return the largest argument
GROUP_CONCAT()
[970] Return a concatenated string
HEX()
[889] Return a hexadecimal representation of a decimal or string
value
HOUR()
[924] Extract the hour
IF()
[883] If/else construct
IFNULL()
[884] Null if/else construct
IN()
[878] Check whether a value is within a set of values
INET_ATON()
[966] Return the numeric value of an IP address
INET_NTOA()
[966] Return the IP address from a numeric value
INSERT()
[889] Insert a substring at the specified position up to the specified
number of characters
INSTR()
[889] Return the index of the first occurrence of substring
INTERVAL()
[879] Return the index of the argument that is less than the first
argument
IS_FREE_LOCK()
[966] Checks whether the named lock is free
IS NOT NULL
[877] NOT NULL value test
IS NOT
[876] Test a value against a boolean
IS NULL
[877] NULL value test
IS_USED_LOCK()
[966] Checks whether the named lock is in use. Return connection
identifier if true.
IS
[876] Test a value against a boolean
ISNULL()
[879] Test whether the argument is NULL
LAST_DAY
[925] Return the last day of the month for the argument
LAST_INSERT_ID()
[961] Value of the AUTOINCREMENT column for the last INSERT
LCASE()
[889] Synonym for LOWER()
LEAST()
[879] Return the smallest argument
<<
[951] Left shift
LEFT()
[890] Return the leftmost number of characters as specified
LENGTH()
[890] Return the length of a string in bytes
<=
[876] Less than or equal operator
<
[876] Less than operator
LIKE
[896] Simple pattern matching
LN()
[910] Return the natural logarithm of the argument
LOAD_FILE()
[890] Load the named file
LOCALTIME()
,
LOCALTIME
[925] Synonym for NOW()