| Function | Returns |
ascii | the decimal representation in the database character set of the first character of char |
asciistr | ASCII version of string |
chartorowid, rowidtochar, rowidtonchar | a rowid (and vice versa) |
chr, nchr | char or nchar that corresponds to ASCII passed as argument |
collation, nls_collation_name | name of collation |
compose | |
concat | Concatenate strings, compare with the || operator. |
convert | Convert a string from one character set to another. |
empty_clob | an empty CLOB locator |
hextoraw, rawtohex, rawtonhex | a RAW that corresponds to the hexadecimal representation that was given as argument to hextoraw; and vice versa |
initcap, nlsinitcap | |
instr | |
length | length of a string |
lpad, rpad | Left or right pad a string (so that the result has a given length) |
ltrim, rtrim, trim | Removes spaces on one or both ends of a string. |
lower, upper, nlslower, nlsupper | |
nlssort | |
reftohex | |
replace | Replaces given substrings in a string with other substrings |
soundex | |
substr | Return a portion (i. e. a substring) of a (longer) string |
to_char, to_nchar, to_clob, to_nclob | |
to_multi_byte | |
translate, translate using | string where given set of characters are replaced with another set of characters |
unistr | |
validate_conversion | a number that corresponds to the possibility to convert one data type to another |