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 |