String Functions

FunctionDescription
ASCIIGives the ASCII value of the first character of a string.
CHR(n)Character with ASCII value n
CONCATConcatenates two strings
INITCAPChanges the first letter of a string or series of words into uppercase.
INSTRReturns the beginning location of a pattern in a given string.
LENGTHReturns the length of a string.
LOWERConverts every letter of a string to lowercase.
LPADAdds a specified set of characters to the left of the original string.
LTRIMRemoves a set of characters from the left of a string.
REGEXP_COUNTReturns the number of times the pattern is found.
REGEXP_INSTRReturns the location of a pattern in a given string and supports the regular expression.
REGEXP_LIKESearches x for the regular expression defined in the pattern parameter.
REGEXP_REPLACEReplaces string with the regular expression matching supports
REGEXP_SUBSTRReturns the substring with the regular expression matching supports
REPLACEDoes the string replacement
RPADAdds a specified set of characters to the right of the original string.
RTRIMRemoves a set of characters from the right of a string.
SOUNDEXConverts a string to a code value based on similar sounds.
String||StringConcatenates two strings.
SUBSTRRetrieves a portion.
TRANSLATEReplaces a string character by character.
TRIMRemoves a set of characters from both sides.
UPPERConverts every letter to uppercase.
VSIZEReturns the storage size.
Home »
Oracle » 
String_Functions