Oracle Character Functions

Oracle ASCII() is a built-in function that returns the decimal numeric representation of the first character in the string specified by the parameter.

Oracle CHR() is a built-in function that returns the character corresponding to the given integer parameter.

Oracle CONCAT() is a built-in function that returns the concatenated string of two given parameters.

Oracle INITCAP() is a built-in function that capitalizes the first letter of each word in a given string and converts all other letters to lowercase.

Oracle INSTR() is a built-in function that searches for a substring in a given string and returns an integer that represents the index position of the string.

Oracle LENGTH() is a built-in function that returns the character length of a given string.

Oracle LOWER() is a built-in function that returns the lowercase form of the given string.

Oracle LPAD() is a built-in function that left-pads a given string with a specified character sequence to make it a given length.

Oracle LTRIM() is a built-in function that returns a string with any specified leading characters (by default, spaces) removed.

Oracle NCHR() is a built-in function that returns the character corresponding to the given integer parameter as a NVARCHAR2 type.

Oracle NLS_INITCAP() is a built-in function that converts the first letter of each word in the given string to uppercase and the other letters to lowercase.

Oracle NLS_LOWER() is a built-in function that returns the lowercase version of a given string.

Oracle NLS_UPPER() is a built-in function that returns the uppercase form of a given string.

Oracle NLSSORT() is a built-in function that returns the collation key for a given string and the explicitly or implicitly specified collation.

Oracle REGEXP_COUNT() is a built-in function that returns the number of occurrences of a given regular expression pattern in a source string.

Oracle REGEXP_INSTR() is a built-in function that returns the index of a substring that matches a given regular expression pattern in a source string.

Oracle REGEXP_REPLACE() is a built-in function that replaces a string with new content that matches a specified regular expression.

Oracle REGEXP_SUBSTR() is a built-in function that searches a given source string and returns a string that matches the given regular expression.

Oracle REPLACE() is a built-in function that replaces all occurrences of a specified substring in a string with a new substring.

Oracle RPAD() is a built-in function that pads a given string with a given character sequence on the right side to reach a specified length.

Oracle RTRIM() is a built-in function that returns a string with any specified trailing characters (by default, spaces) removed.

Oracle SOUNDEX() is a built-in function that returns a string representing the pronunciation of a given English string.

Oracle SUBSTR() is a built-in function that returns a specified length substring starting from a specified position in a string.

Oracle TRANSLATE() is a built-in function that translates a given string based on a specified translation relationship and returns the translated string.

Oracle Oracle TRANSLATE(using) is a built-in function that converts the given string between the database character set and the national character set.

Oracle TRIM() is a built-in function that returns a string with any specified leading and trailing characters (by default, whitespace) removed.

Oracle UPPER() is a built-in function that returns the uppercase form of a given string.