Oracle 5.0, Reference Manual

Page: 905 / 3232

String Functions
885
Name Description
ELT()
[888] Return string at index number
EXPORT_SET()
[888] Return a string such that for every bit set in the value bits,
you get an on string and for every unset bit, you get an off
string
FIELD()
[888] Return the index (position) of the first argument in the
subsequent arguments
FIND_IN_SET()
[888] Return the index position of the first argument within the
second argument
FORMAT()
[889] Return a number formatted to specified number of decimal
places
HEX()
[889] Return a hexadecimal representation of a decimal or string
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
LCASE()
[889] Synonym for LOWER()
LEFT()
[890] Return the leftmost number of characters as specified
LENGTH()
[890] Return the length of a string in bytes
LIKE
[896] Simple pattern matching
LOAD_FILE()
[890] Load the named file
LOCATE()
[890] Return the position of the first occurrence of substring
LOWER()
[890] Return the argument in lowercase
LPAD()
[891] Return the string argument, left-padded with the specified
string
LTRIM()
[891] Remove leading spaces
MAKE_SET()
[891] Return a set of comma-separated strings that have the
corresponding bit in bits set
MATCH
[934] Perform full-text search
MID()
[891] Return a substring starting from the specified position
NOT LIKE
[898] Negation of simple pattern matching
NOT REGEXP
[899] Negation of REGEXP
OCT()
[891] Return a string containing octal representation of a number
OCTET_LENGTH()
[891] A synonym for LENGTH()
ORD()
[891] Return character code for leftmost character of the argument
POSITION()
[892] A synonym for LOCATE()
QUOTE()
[892] Escape the argument for use in an SQL statement
REGEXP
[899] Pattern matching using regular expressions
REPEAT()
[892] Repeat a string the specified number of times
REPLACE()
[892] Replace occurrences of a specified string
REVERSE()
[892] Reverse the characters in a string
RIGHT()
[892] Return the specified rightmost number of characters
RLIKE
[899] Synonym for REGEXP
RPAD()
[892] Append string the specified number of times